This page describes several common database
administration and reporting tools that you can use to connect to your Cloud SQL instances.
## Overview
Database administration and reporting tools provide varying degrees of support
for managing your database. Select a tool based on the type of
administration and reporting that you need to do. For example, if you need to
connect to one database and issue a few SQL commands, consider
using the MySQL client.
See [Connecting MySQL Client Using IP Addresses](https://docs.cloud.google.com/sql/docs/mysql/connect-admin-ip.md.txt).
If you need to design or manage many databases simultaneously, then
use one of the visual-based tools discussed here.
We discuss a limited number of tools in this page. If your tool
is not discussed, it's likely that you can successfully connect by following
the steps for a similar tool.
## Connect with MySQL Workbench
This section shows how to connect to your
Cloud SQL instance database with
[MySQL Workbench](http://www.mysql.com/products/workbench/).
> [!NOTE]
> Note: Add your MySQL Workbench machine's IP address as an [authorized network](https://docs.cloud.google.com/sql/docs/mysql/authorize-networks.md.txt) for your Cloud SQL instance.
1. In the MySQL Workbench home view, click **New Connection**.
2. In the **Setup new connection** form, provide a **Connection Name** , **Hostname** , **Username** , and **Default Schema** , if applicable, as show in Figure 1.
 Figure 1: New connection in MySQL Workbench **Setup New Connection** form.
3. Click **Test Connection**. You are prompted for a password.
4. Optionally, click **Advanced** , and fill in the information for connecting with SSL as shown in Figure 2. Be sure to select **Use SSL if available** and specify an **SSL CA File** , an **SSL CERT File** , and an **SSL key File** . [Learn more](https://docs.cloud.google.com/sql/docs/mysql/authorize-ssl.md.txt) about using SSL certificates with Cloud SQL.
 Figure 2: Specifying advanced options in the MySQL Workbench **Setup New Connection** form.
5. Click **Test Connection** to make sure all the advanced parameters are set correctly.
6. Click **Close**.
7. Connect with the connection you created.
8. Once connected, you can test if you're using SSL by executing the following SQL statement:
```sql
SHOW STATUS like 'ssl_cipher';
```
 Figure 3: Testing if the MySQL Workbench connection uses SSL.
[Back to top](https://docs.cloud.google.com/sql/docs/mysql/admin-tools.md.txt#top)
## Connect with Toad for MySQL
This section shows how to connect to your
Cloud SQL instance database with
[Toad for MySQL](http://www.toadworld.com/products#mysql).
1. In Toad for MySQL, create a new connection.
2. In the **New MySQL Connection** form, fill in the following information:
- **User**: The name of a user in your MySQL database.
- **Password**: The password for the specified user.
- **Host** : The IP address of your instance. For more information, see [Configuring Application Access Control](http://www.mysql.com/products/workbench/). If you've mapped the IP address to the hostname of your local server, you can use that in this field.
- **Database**: The database instance to connect to.
 Figure 4: The Create New Connection dialog box in Toad for Mac
3. Click **Test Connection** to confirm that the connection information is correct.
4. Click **OK** to start the connection.
5. In the **Enter Password** dialog box, enter the password for the user. This dialog box appears because we did not choose **Save password (encrypted)** in the **Create New Connection** dialog box.
### Configure Toad to use SSL
In Figure 5, a **Create New Connection** dialog box is shown
with information for connecting with SSL. All versions of Toad might not support
connecting with SSL.
 Figure 5: The Create New Connection dialog box in Toad for Windows
Once connected, you can test if you're using SSL by executing the following
SQL statement and verifying that the `ssl_cipher` value is not empty:
```sql
SHOW STATUS like 'ssl_cipher';
```
[Back to top](https://docs.cloud.google.com/sql/docs/mysql/admin-tools.md.txt#top)
## Connect with SQuirrel SQL
This section shows how to connect to your
Cloud SQL instance database with
[SQuirrel SQL](http://www.squirrelsql.org/).
1. In the SQuirrel SQL client, select the **Aliases** panel to make it active.
2. In the **Aliases** menu, select **New Alias**.
3. Fill out the information, as shown in Figure 6. Be sure to select the MySQL Driver and provide values for \, \, and \.
> [!NOTE]
> **Note:** The connection URL for using SSL is of the form:
> `jdbc:mysql://:3306/?verifyServerCertificate=true&useSSL=true&requireSSL=true`.
> However, to use SSL, you must specify truststore files created from the CA certificate,
> the client certificate, and the client key you obtained when you created an SSL certificate.
> For more information, see [Configuring a SQuirrel SQL connection to use SSL](https://docs.cloud.google.com/sql/docs/mysql/admin-tools.md.txt#squirrel-ssl).
 Figure 6: Configuring a SQuirrel SQL connection to MySQL.
4. Click **Test** to test the connection. You are prompted for a password.
5. Click **OK** to save the alias.
6. In the **Aliases** panel, right-click the alias you created and select **Connect**.
### Configure SQuirrel SQL to use SSL
This section assumes that you've created an SSL certificate
(see [Configuring SSL for an instance](https://docs.cloud.google.com/sql/docs/mysql/configure-ssl-instance.md.txt))
and you have three files:
- A CA certificate file, for example, **ca-cert.pem**.
- A client public key certificate file, for example, **client-cert.pem**.
- A client private key file, for example, **client-key.pem**.
Use these files as described in
[Connecting Securely Using SSL](http://dev.mysql.com/doc/connector-j/en/connector-j-reference-using-ssl.html) in the
MySQL Reference Manual to create keystore and truststore files. You need to specify the
keystore and truststore files when you start SQuirrel SQL. One way to do
this is to edit the script that launches the SQuirrel SQL application as follows:
```
$JAVACMD -Djavax.net.ssl.keyStore= \
-Djavax.net.ssl.keyStorePassword= \
-Djavax.net.ssl.trustStore= \
-Djavax.net.ssl.trustStorePassword= \
[existing launch parameters]
```
After you've started SQuirrel SQL with the valid keystore and truststore information, you
can connect with:
```
jdbc:mysql://:3306/?verifyServerCertificate=true&useSSL=true&requireSSL=true
```
Once connected, you can test if you're using SSL by executing the following
SQL statement and verifying that the `ssl_cipher` value is not empty:
```sql
SHOW STATUS like 'ssl_cipher';
```
[Back to top](https://docs.cloud.google.com/sql/docs/mysql/admin-tools.md.txt#top)