I have a small home network running (5 machines) on a central router. I have a Apache server running on one of them with MySQL running as well.
I cannot figure out how to connect to that database with dbForge Studio for MySQL from a different machine.
I can connect locally using phpMyAdmin with user:root@localhost and this works fine.
The machine is at IP 192.168.1.105 and its network name is SAGAN
How do I set up a New Connection to connect to this database?
Connection to server in home network
You should set IP 192.168.1.105 as a host in the connection dialog, then specify user name and password.
You can find more information about how to work with connections in dbForge Studio for MySQL in the "Connecting to Databases" topic in the product's documentation.
Note: the specified user must be created with host as '%'. This allows you to connect to the MySQL server from other hosts. You can learn about working with Security Manager at http://www.devart.com/dbforge/mysql/stu ... nager.html
You can find more information about how to work with connections in dbForge Studio for MySQL in the "Connecting to Databases" topic in the product's documentation.
Note: the specified user must be created with host as '%'. This allows you to connect to the MySQL server from other hosts. You can learn about working with Security Manager at http://www.devart.com/dbforge/mysql/stu ... nager.html