NAVICAT solution for remote connection to Mysql _mysql

Recently installed a MySQL 5.0 on Ubuntu, because the use of phpMyAdmin must also install PHP, so I intend to use the Remote administration tool navicat for MySQL to connect directly.

Create a data table with the MySQL command line in Ubuntu and assign permissions:

Copy Code code as follows:

GRANT all on testdb.* to UserA identified by ' passwd '

Then restart the load permission:

Copy Code code as follows:

Mysqladmin–uroot–p flush-privileges

You are still prompted for no permissions after using the Navicat connection:

Copy Code code as follows:

2003–can ' t connect to the MySQL server on ' Ubuntu ' (10061)

View the Mysql.user table, UserA does have access to any host.

So the idea is that MySQL Server binds the local address, opens/ETC/MYSQL/MY.CNF, and finds:

Copy Code code as follows:

Bind-address = 127.0.0.1

Remove the IP address binding and change it to:

Copy Code code as follows:

Bind-address = 0.0.0.0

Then restart MySQL Server:

Copy Code code as follows:

/etc/init.d/mysql restart

So Navicat can be connected properly, Debian should have the same problem.