My problem is:
I have a remote mysql server and i cant connect to it . I granted all privilege to root from my ip address (i have a static one) and still when i try to conect to my server i still have the message
ERROR 2003 (HY000): Can't connect to MySQL server on (XXX.XXX.XXX.XXX)
Here is what i did :
mysql>GRANT ALL PRIVILEGES ON *.* TO root@XXX.XXX.XXX.XXX IDENTIFIED BY "**********";and on my local machine
localhost ~ # mysql --host=XXX.XXX.XXX.XXX --pass Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on 'XXX.XXX.XXX.XXX' (111)
Anyone can point me where i did my error?