Navicat and MySQL
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?