navicat cannot connect to mysql remotely

Recently, I installed MySQL 5.0 on Ubuntu. Since PHP must be installed to use phpMyAdmin, I plan to connect directly using the remote administration tool Navicat for MySQL.

In Ubuntu, 1 data table was created through the mysql command line and permissions were assigned:

GRANT ALL ON testdb.* TO usera IDENTIFIED BY  ' passwd'

Then restart the load permissions:

mysqladmin  � uroot  � p flush-privileges

When using Navicat to connect, the user is still prompted without permission:

2003  �  Can't connect to MySQL server on  ' ubuntu'(10061)

Looking at the ES28en.user table, usera does have access to any host.

So wondered if MySQL Server binding local address, open/etc/mysql/my cnf, find:

bind-address = 127.0.0.1

Remove the IP address binding and change it to:

bind-address = 0.0.0.0

Then restart MySQL Server:

/etc/init.d/mysql restart

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