Adding a New MySQL Connection via SSH Tunnel

In the Explorer pane, click on the plus icon next to CONNECTIONS.

This launches the Add Connection window where you can create new connections from TeamSQL to your server(s).

 

To create a connection to a MySQL database set the Database Type to MySQL.

 

Note how the window now displays Create a new MySQL connection at the top.

To connect to your MySQL database server, you’ll need to provide the following parameters to TeamSQL:

 

Connection Name
A descriptive name for your connection

Host
The host address TeamSQL will use to access your MySQL server

Port
The port through which TeamSQL uses to communicate with your MySQL server

User Name
The username TeamSQL uses to log in and gain access to your MySQL server

Password
The password that accompanies the username TeamSQL uses to log in and gain access to your MySQL server

Default Database
The database within your MySQL server you want TeamSQL to consider your default

Production Server?
A flag indicating whether the MySQL server is a production instance or not

SSH Tunnel
The flag indicating whether TeamSQL should enable an SSH tunnel through which it connects to your server

 

Connecting Through an SSH Tunnel

TeamSQL allows you to connect to your server via SSH Tunnel. If you’ve enabled this option for your connection, you’ll be prompted to provide the following credentials:

Host
The host address TeamSQL uses to access the server you’ll use to connect to the MySQL server

Port
The port on the server connecting to your MySQL server that you want to use for communications

Username
The username you use to log in to the server you use to connect to your MySQL server

Password
The passport you use to log in to the server you use to connect to your MySQL server

Private Key File
A file containing a private key you use to log in to the server you use to connect to your MySQL server

For authentication purposes, you can use either:

  • Your username and password, or;
  • Your username and a private key.

 

Once you’ve provided the appropriate parameters, you can click Test Connection to see if the details you’ve provided TeamSQL are correct. If they are, click Save Connection.

 

You will now see your newly-created connection in your Explorer panel. By default, TeamSQL creates connections in a disabled state. Click on the socket icon to enable the connection.

 

Once connected, you’ll see a green checkmark next to your connection’s name, as well as a drop-down list of the databases available on your server.