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:
- added #bind-address = IPA in my.cnf file on server B and restarted mysql;
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)