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:
A descriptive name for your connection
The host address TeamSQL will use to access your MySQL server
The port through which TeamSQL uses to communicate with your MySQL server
The username TeamSQL uses to log in and gain access to your MySQL server
The password that accompanies the username TeamSQL uses to log in and gain access to your MySQL server
The database within your MySQL server you want TeamSQL to consider your default
A flag indicating whether the MySQL server is a production instance or not
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:
The host address TeamSQL uses to access the server you’ll use to connect to the MySQL server
The port on the server connecting to your MySQL server that you want to use for communications
The username you use to log in to the server you use to connect to your MySQL server
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.