Hi Everyone,

I am trying to use a MySql application that will allow me to make changes to my databases remotely. I have tried several application for example Navicat, MySQL Monitor, Toad, etc. I undersatand that Mysql is running on port 3306, but everytime I login I get a message stating that the ip on the remote machine does not have access to the database on the the Mysql server (port 3306). Anyone know how to connect to mysql using a remote application. Better yet, anyone know where and how to add the ip address to be allowed to connect to Mysql. Any help would be greatly appreciated.

Pete

http://dev.mysql.com/doc/mysql/en/adding-users.html

you're looking to 'grant' access to your username from another ip

edit:
the second example--
gives full privileges on all databases/tables to user 'monty' from ANY host using password 'some_pass' including the ability to grant privileges to other users. -- meaning monty can do anything from anywhere