MySQL not Remotely accessable

[Obligated]

I am trying to connect to MySQL database with Navicat

Host Name/IP Address: XXX.XXX.XX.XXX
Port: 3306
User Name: root
Password: ******

I place in all the correct info and I get an error

Code: Select all

2003 - Can't connect to MYSQL server on 'XXX.XXX.XX.XXX' (10061)

I looked up the error and this is what I found
http://stackoverflow.com/questions/2584 ... host-10038

I solved this problem. In my /etc/mysql/my.cnf, the command bind the locahost address like this: bind-address=127.0.0.1, just add a # before it. and now I can connect to the mysql server smoothly.

I did what he said in the awnser and I get an other error

Code: Select all

1045 - Access denied for user 'root'@'ip"My_IP" (using passworrd: YES

• All websites I used and did not help:
  http://www.rackspace.com/knowledge_cent ... -on-ubuntu
  http://stackoverflow.com/questions/2584 ... host-10038
  http://stackoverflow.com/questions/1559 ... sql-server
  http://stackoverflow.com/questions/1370 ... ng-navicat
  http://stackoverflow.com/questions/1420 ... -error-111
  http://dba.stackexchange.com/questions/ ... d-for-user
  https://community.navicat.com/forum/nav ... e-afrihost
  http://serverfault.com/questions/230012 ... ootx-x-x-x

If you have a suggestion please tell me.

[$atanic $pirit]

Are you connecting to and from NFO powered servers? From what I know, by default NFO won't allow other hosts to connect to their SQL databases. You need to open a ticket and ask them to allow that particular IP.