A MySQL connection is established using TCP/IP, which means that TCP/IP should be your minimum requirements for your computer's network interface. A few things are very important to know when connecting to MySQL:
| 1. | You computer needs access to the TCP/IP port on which MySQL is listening on the remote (or local) MySQL host machine. This means you should not have firewalls and/or proxies blocking your TCP/IP path to the MySQL server.  You can setup an SSH tunnel to connection any two machines securely, MyCon also supports an SSL MySQL connection.
|
| 2. | MySQL must be setup to allow access from remote machines (this is by default the case, but can be disabled by an ISP for example)
|
| 3. | You need a valid MySQL username and password with remote access to MySQL server, this means your username and password must be added on the MySQL server using the GRANT command (see MySQL Manual) which grants your user access from your IP address or using the any IP wildcard "%". By default MySQL only allows access to the "root" username on the localhost machine. So if your MySQL server is running at an ISP along with your website you might see that your website and tools like telnet or phpmyadmin can access the MySQL server, but you might be unable to from your workstation. This is because telnet runs on the local MySQL host, you just have a remote connection giving you a localhost telnet session, while phpmyadmin is effectively a website running on the same machine as the MySQL server, which means you actually also use localhost access to your MySQL. However you might be unable to access your server because the ISP firewalled the MySQL server or did not grant your username remote access to the MySQL server.
|
|
|
| To initially setup and configure your MySQL connection, please see Create a new MySQL Connection.
|
|
|
 If you have an SSL enabled version of MyCon, you will see and have the SSL options as well. Just enable it and fill in the resulting additional fields with your SSL certificates and paths (see MySQL Manual SSL Setup).
|
|
|
| MyCon is capable of connecting to your MySQL server using three different methods:
|
| 1. | Direct, this means MyCon will use a straight and direct TCP/IP connection to your MySQL server without relying on any external files or dlls.
|
| 2. | ClientLibrary, is the normal way to connect to MySQL, i.e. using the MySQL AB provided libmysql.dll client library. If you select this option, you will get an additional box where you can specify the library to use.
|
| 3. | Embedded. MyCon allows you to connect to a MySQL database using the embedded MySQL server (which usually ships with MySQL as libmysqld.dll). This means you connect not to a MySQL server, but directly to the actual database, in other words, your MyCon physically becomes the MySQL server (without the capability to takes outside connections). MyCon allows you only one such connection, i.e. MyLook allows you to add the MyCon module multiple times for multiple connections to different MySQL servers, but only one of them may use the Embedded driver.
|
If you pick either Direct (default) or ClientLibrary, you will have to complete the Server section of properties as well. Here you can specify your MySQL hostname, the TCP/IP port it is listening on, connection timeout (in seconds, thus if you can't connect within this time, you will be notified), your mysql username and password. Once completed you can click Test to test your parameters to see if you can connect successfully and then click Apply to save your settings.
Because the connection settings change, all folder windows which are open and using this connection, ex. Tables, Queries, Reports, etc, will be automatically closed when you change the settings, so be sure to save your work beforehand.