Search This Blog

Lets go..

Thursday

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

1 comment:

  1. Thanks Author: Md Mahfuj Jia.
    All your tutorials are very very good its easy to understand and quickly adaptable.

    ReplyDelete

Thanks for your opinion