Navicat, MySQL and VMWare

To connect to a mySQL Db on a VMWare appliance, I needed to edit the /etc/mysql/my.cnf file.

Command: nano /etc/mysql/my.cnf

Action: comment (using #) the 'bind-address = 127.0.0.1'

Desc: This command binds the mysql server to only accept connections from the localhost. Great for security, bad for development. So unless you want to use command line mysql, you need to change this. Bad idea for a production mysql server as it opens the server to outside connections.

Note: the linux turnkey webadmin will let you add a user but it will not alert you to the requirements to change the my.cnf file.

Use either the command line or the webadmin to stop and restart the mysql server. Permissions will not show until it restarts.