Remote MYSQL connection error

If you get a error if you try to a mysql databse whose servers IP
is(203.112.28.111 ) from a remote PC and get the following errors

[root@server ~]# mysql -h 203.112.28.111 -u root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 203.112.28.111 (113)

Also on the server i cannot stop the firewall setting cuse of security
reasons .....

then i have to do the followingon the mysql databases servers :

In my mysql server where the databes is located , i have edited the
/etc/my.cnf and did the following :
bind-address = host ip
# skip-networking

I log to mysql and
GRANT ALL PRIVILEGES ON *.* TO root@client'sipaddress IDENTIFIED BY
'root's_password';

quit;

Edited the /etc/sysconfig/iptables
i moved :
#########################################################
-A INPUT -p tcp -m tcp -s [clients IP-addr} --dport 3306 --sport
1024:65535 -j ACCEPT
##########################################################
to the top of the firewall rule before the blocking rules ....

Restart the iptables

then frm the then client machine try
mysql -h ipaddresss -u root -p
( you should be able to log to the mysql database )

No comments:

Other Articles

Enter your email address: