Dear Agnello,
On 9/12/07, Agnello George wrote:
Hi i am trying to connet to a mysql databse whose servers IP is( 203.1123.28.111 ) from a remote PC and get the following errors
[root@server ~]# mysql -h 203.1123.28.111 -u root -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 203.1123.28.111 (113)
Also on the server i cannot stop the firewall setting cuse of security reasons ..... most of the help on line say that the problem is resolved if the server's fire wall is disabled .
Just add a rule to accept/allow connection to port 3306 (MySQL). However, it's better to put a rule to just allow connection from some known IP Addresses / host names for security reasons.
You will require to put your source IP(s) in MySQL Access Control list to allow remote connections over network. Default MySQL only allows connection from localhost (127.0.0.1). Please refer MySQL Docs for Access Control.
Does any one have any ideas how to get around this !!!
-- Warm Regards
Agnello . G .Dsouza
HTH With regards,