|
I sometimes forgot how to configure my SQLyog program to remote the MySQL database so I decided to put it here on my site just for reference
As default the MySQL database can be access locally on the same pc but how about you are going to access it from other pc on your network, a very simple steps are the following:
On the SQLyog running on local pc where mysql database are running create a new user and configure all permissions, the user host will be % to allow access from any computer.
Open the firewall configuration of the same pc and add an exemption port and add the following port address 3306, TCP and UDP.
Now try accessing your mysql database from other pc and supply the user login information that you have newly created on the MySQL server
|