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:
Post a Comment