In a few step you can allow remote system to access your MySQL server. To implement first you will need to configure your my.cnf which which is located at
/etc/mysql/my.cnf [Debian Linux Environment]
OR
/etc/my.cnf [Red Hat Linux/Fedora/Centos Linux]
OR
/var/db/mysql/my.cnf [FreeBSD]
access the file using
sudo gedit /etc/mysql/my.cnf
check for following line
bind-address in which the local ip address is assigned 127.0.0.1
bind-address = 127.0.0.1
So just replace the local ip address with your server ip address e.g. 192.168.XXX.XXX
bind-address = 192.168.XXX.XXX
Thats it now all you need to restart your MySQL server and assign a grant access to remote system.
To restart MySQL server
etc/init.d/mysql restart
To assigned a grant access
GRANT ALL ON user_database_name.* TO remote_user_name@'192.168.x.x' IDENTIFIED BY 'PASSWORD';
Thats it and it is done.. Now
the remote user can access your db..
Saturday, October 4, 2008
Subscribe to:
Posts (Atom)