Error while connecting to sql database

Question

I am trying to access a sql database remotely. The database and the server are on two different ips. i have tried commenting out bind-address line and all the other things people have suggested in different posts but am still unable to connect to the sql database.

m using on my server ..

$ mysql -u name -h server-address -p

and am getting.

ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' (111)

Note: I have already granted all privileges to the specific user name and the web server and sql database is on ubuntu server.

SQL EXCEPTION : Failed to link account

Answer 1

The (111) in parenthesis gives you what's wrong. (Access denied)

This page on MySQL.com covers this issue fairly extensively, I'd start there.

Chances are there's something off with the host part of your grants;

Answer 2

You may need to just simply grant access.

mysql> CREATE USER 'MY_USERNAME'@'localhost' IDENTIFIED BY 'MY_PASSWORD'

mysql> GRANT ALL PRIVILEGES ON 'MY_DATABASE'.* TO 'MY_USERNAME'@'12.34.56.78' IDENTIFIED BY 'MY_PASSWORD';