Once you start SQLyog, you will get a figure as shown below. The connection window allows you to connect to the MySQL server.
SQLyog gives you a choice between four different connectivity options. No matter whatever your firewall/proxy/ISP settings are, you should be able to smartly manage your MySQL Server(s). The various connectivity options (in the order of responsiveness and network efficiency) are:
- Direct connection using MySQL C API: This is by far the fastest way to connect and manage your MySQL server. This is the preferred method if you are not concerned about your MySQL traffic being spoofed. However, this requires direct access to your MySQL server. Most ISPs block the MySQL port or disallow remote access.
- SSH Tunneling *: Use this option if you need to encrypt the contents of your MySQL traffic, but still want the efficiency of the MySQL C API. If your host supports SSH tunneling, SQLyog can use the tunnel to communicate with MySQL.
- HTTP Tunneling *: This option saves your day if your ISP/MySQL provider disallows remote access, either by blocking the MySQL port or by giving access to “localhost” only. The response is slow compared to the previous options since the data is XML encoded and HTTP is stateless by nature. However, you can use all the cool features of SQLyog (and start getting more sleep!).
- HTTPS Tunneling *: This option is similar to HTTP Tunneling but adds another layer of security by establishing a secure channel. *
- SSL Encryption *: With this option all communication between SQLyog and the MySQL server is encrypted. The MySQL server must support this option. Not all servers do!
To get more information on how to connect using your preferred method, click on one of the topics below.
*: This feature is available in SQLyog Professional, Enterprise and Ultimate.
If you are using SQLyog for the first time then you have to first create an instance of your database connection. You can do this by clicking on New button in the connection manager dialog
- New- Click the new button. In the name field (figure shown right) type the name by which you will recognize the connection. By default SQLyog will create an instance with default values (e.g. localhost, root).
- Save- This button allows you to save any change in the connection details.
- Rename- Click the rename button to rename a connection. Note that Connection Names are names used internally by SQLyog only (and not MySQL). Connection Names are used by SQLyog for storing the connection details. Also, certain SQLyog functionalities will make use of the connection name as stored by SQLyog.