Connect SQuirreL to MySQL on macOS

Mac Tutorials - Herong's Tutorial Examples

∟Connect SQuirreL to MySQL on macOS

This section provides a tutorial on how to download MySQL JDBC driver and connect SQuirreL to MySQL server on macOS.

If you are running a MySQL database server local on your macOS, you can download MySQL JDBC driver and start to use SQuirreL to manage the database.

1. Install JDBC driver for MySQL Server:

Go to MySQL JDBC driver Website at at dev.mysql.com/downloads/connector/j/.
Download mysql-connector-java-8.0.18.tar.gz from the platform independent section.
Open the downloaded TAR file by running "tar -xf mysql-connector-java-8.0.18.tar".
Move JDBC driver files to /Library by running "mv mysql-connector-java-8.0.18 /Library/Java/JDBC".

2. Add JDBC driver for SQL Server to SQuirreL:

Start SQuirrel by going to "Applications > Squirrel".
Click "Drivers > MySQL > Extra class path > +" to add the driver file.
Select "/Library/Java/JDBC/mysql-connector-java-8.0.18/mysql-connector-java-8.0.18.jar". When the driver file is loaded, MySQL JDBC driver is ready.

7. Add connection alias to MySQL database.

Start SQuirrel by going to "Applications > Squirrel".
Click "Aliases > +" to add a new connection alias.
Select "MySQL JDBC Driver" and enter server address, login name and password.
Click "Test" to verify the connection.

8. If you get the "The server time zone value 'EDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support", don't panic. You can connect to MySQL server with "mysql" and fix the timezone:

mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | EDT    |
| time_zone        | SYSTEM |
+------------------+--------+
2 rows in set (0.00 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-10-28 22:51:43 |
+---------------------+
1 row in set (0.01 sec)

mysql> set time_zone = '-04:00';
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone | EDT    |
| time_zone        | -04:00 |
+------------------+--------+
2 rows in set (0.01 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2019-10-28 22:58:35 |
+---------------------+
1 row in set (0.00 sec)