Can't connect to mysql database remotely ERROR 2003

516 views Asked by At

I want to connect from server A to mysql database on server B. Let's say A's ip is IPA, and B's is IPB. I've done two things:

  1. added #bind-address = IPA in my.cnf file on server B and restarted mysql;
  2. granted all privileges to user on server A that is trying to connect to B's database using this line:

    GRANT ALL PRIVILEGES ON *.* TO 'userA'@'IPA' WITH GRANT OPTION;

and restarted mysql.

Still, executing this on server A:

mysql -uUserA  -pPassA -hIPA

gives me error: ERROR 2003 (HY000): Can't connect to MySQL server on 'IPA' (110)

0

There are 0 answers