Chris W wrote:
By default MySQL uses port 3306 so you need to be sure that port is open on the server, and not blocked by a firewall. You also need to be sure the user you are trying to login as can login remotely. In the MySQL user data base, there is a column for host which is the host that user can login from. If that host says localhost you can only login from the localhost. If it says % you can login from any host. Also note there can be more than one entry for each user all with a different host. It is best to only set it up so you can login from a specific host, that makes it more difficult for a hacker to break in. If the user you are logging in as is set up just for localhost I would add a user and use the host you plan to login from if you can, other wise just change the host to % then you can login from anywhere. Also if you do an update to the user table, using the sql update command, you also need to execute flush privileges for the changes to take effect.
The other thing is that mysql has to be set up to allow remote connections, it's not by default on some systems (eg debian).
Check the my.cnf and make sure there is no 'skip-networking'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
