08-08-2009

MySQL Enable remote access on MySQL

For instance when accessing a server using MySQL Query Browser you need to enable remote access, or you'll receive errors 1130 or 2003.

First of all find the my.cnf file and edit following line:

bind-address=YOUR-SERVER-IP

Now grant access to your remote user to the appropriate databases (in this example all databases)

mysql> GRANT ALL PRIVILEGES ON *.* TO user@ip_remote_not_server IDENTIFIED BY 'password' WITH GRANT OPTION;

Comments:

Your comment:

»

 

[x]