How to establish MySQL remote connection

Bind your ip address ::

[root@db-tom ~]# vim /etc/my.cnf

Add bind-address = 10.12.21.11 (your machine ip address) in my.cnf file

Note : your network must have static private ip (not DHCP) in case of private network or public ip

mysql -uroot -p

password:*******

use mysql;

mysql> GRANT ALL PRIVILEGES ON *.* TO  'USERNAME'@'%'  IDENTIFIED  BY  'PASSWORD';

mysql>FLUSH PRIVILEGES;

mysql>exit

[root@db-tom ~]# /etc/init.d/iptables start

[root@db-tom ~]# chkconfig iptables off