Mac Tutorials - Herong's Tutorial Examples - v3.08, by Herong Yang
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:
2. Add JDBC driver for SQL Server to SQuirreL:
7. Add connection alias to MySQL database.
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)
The error should go away now.
Table of Contents
Macintosh OS (Operating System) History
System and Application Processes
Keychain Access - Password Manager
Keychain Access - Certificate Manager
Install New Version of Python on macOS
pip3 - Package Installer for Python 3
Install MySQL Database Server on macOS
PHP mysqli_connect() Error on "localhost"
Install SQuirreL SQL Client on macOS
►Connect SQuirreL to MySQL on macOS
Install SQuirreL SQL Scripts Plugins