Connecting to a remote MySQL server

With MySQL you can specify and limit users to be only able to connect from specific computers. A default MySQL installation only allows users to connect to it from the "localhost" (the same computer as the one on which MySQL is installed and running).

For a remote client tool like DeZign for Databases, you need to have remote access privileges to the MySQL server. You must use your client IP address or a %-wildcard in the Host column of the mysql.user table next to your username. For more information on connecting to a remote MySQL server see the MySQL documentation (Security and GRANT topics).

http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/en/old-client.html


See also: How to connect to an Oracle database?