Step # 1: Login through ssh to your server

Step # 2: Enable networking

Once connected you need edit the mysql configuration file my.cfg using text editor such as vi.

# vi /etc/my.cnf

Step # 3: Once file opened, locate line that read as follows

[mysqld]

Make sure line skip-networking is commented (or remove line) and add following line

bind-address=YOUR-SERVER-IP

For example, if your MySQL server IP is 10.10.10.1 then entire block should be look like as follows:

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/English
bind-address = 10.10.10.1
# skip-networking

********

********

Step# 4 Save and Close the file

Restart your mysql service to take change in effect:

# /etc/init.d/mysql restart

Step # 5 Grant access to remote IP address

# mysql -u root -p mysql

# mysql> GRANT ALL PRIVILEGES ON *.* TO root@'10.10.10.1' IDENTIFIED BY 'PASSWORD';

# mysql> exit

# Service mysql restart

Step # 7: Test it

$ mysql -u root –h yoursreverip –p

=======================================================================

Enjoy Linux !!!