MySQL Remote Database server connecting from Client server

My web site : Info Tech Vedas
 

1. Remote database server  
    Example IP address:
   
    Public : 190.60.200.50
    Private : 10.100.79.5
   
    Create user access for Client server ‘Private IP: 10.100.69.7’
        create user root@'10.100.69.7' IDENTIFIED BY 'testpass';
        GRANT ALL ON *.* to root@'10.100.69.7' IDENTIFIED BY 'testpass';
        FLUSH PRIVILEGES;

    Open mysql conf file and find out “bind-address” comment this line save and exit
        vim /etc/mysql/my.cnf
        # localhost which is more compatible and is not less secure.
        #bind-address            = 127.0.0.1

    Restart MySQL server using command:
        sudo /etc/init.d/mysql restart

2. Client server
    Example IP address:
   
    Public :  160.70.100.61
    Private : 10.100.69.7

    Connecting MySQL Remote server using “Private IP 10.100.79.5”:
        mysql -h 10.100.79.5 -u root -ptestpass

Note: Above command is tested on Ubuntu, Fedora and Debian linux.