Tutorials...Videos...Knowledge Base...And More............

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).

See also: How to connect to an Oracle database?

Back to Knowledge Base DeZign for Databases