Navicat and MySQL
 

Greetings all,

I just setup a new machine running Ubuntu Server 9.10, MySQL 5.1.37 and Apache2. I am attempting to connect to the MySQL database using Navicat but I'm getting an error (10061)"Cannot connect to some_host@whatever". I have done the following:

1. Ensured the user I was connecting as was properly added and given the necessary privileges from the subnet I am working from

2. Made sure port 3306 was open and listening for TCP/IP connections

3. Disabled UFW (ubuntu default firewall)

Still can't connect, but I can access the database from shell using putty.

Has anyone else encountered this problem?

Have you checked that MySQL is listening for remote connections? (check out the mysql.users table for this info). Is the MySQL server service running?

Problem solved....issue was in the my.cnf config file only allowing connections from localhost.