Re: Remote connection to MySQL database - HELP

[Michael Corr]

it sounds like your user permissions are not set up correctly. It's possible to limit individual users to specific databases and tables based on the host they connect from and many other possible combinations.

read the section in the manual about GRANT; this may clear things up
http://dev.mysql.com/doc/mysql/en/grant.html

to see what your current permissions are, type:
mysql>SHOW GRANTS;

to see what users and permissions are set up look at the 'User' table in the mysql database
mysql>SELECT user,host from mysql.user;
mysql>SELECT * from mysql.user\G

hope that helps
Michael