How does navicat fail to remotely connect to mysql?

Recently, a MySQL 5.0 is installed on Ubuntu. Because phpMyAdmin must also be installed, we plan to directly use the remote management tool Navicat for MySQL to connect.

Create a data table through the mysql Command Line in Ubuntu and assign permissions:

Copy codeThe Code is as follows:
Grant all on testdb. * TO usera identified by 'passwd'

Then restart the load permission:

Copy codeThe Code is as follows:
Mysqladmin-uroot-p flush-privileges

After using the Navicat connection, the system still prompts that you do not have the permission:

Copy codeThe Code is as follows:
2003-Can't connect to MySQL server on 'ubuntu '(10061)

View the mysql. user table. usera does have the permission to access any host.

If the MySQL Server is bound with a local address, open/etc/mysql/my. cnf and find:

Copy codeThe Code is as follows:
Bind-address = 127.0.0.1

Remove the IP Address binding and change it:
Copy codeThe Code is as follows:
Bind-address = 0.0.0.0

Then restart MySQL Server:

Copy codeThe Code is as follows:
/Etc/init. d/mysql restart

In this way, Navicat can be connected normally, and the same problem should occur in Debian.