MySQL Installation on macOS

JDBC for MySQL - Herong's Tutorial Examples

∟MySQL Installation on macOS

This section describes how to download, install and start MySQL server on macOS systems.

MySQL database server is a good alternative to Oracle and SQL Server, if you are looking for a free database server. Here is what I did to install MySQL database on macOS.

1. Go to MySQL download Website at https://dev.mysql.com/downloads/mysql/.

2. Click "Download" next to "macOS 10.14 (x86, 64-bit), DMG Archive". Enter your Oracle login name and password to start the download.

3. Double-click the download file mysql-8.0.17-macos10.14-x86_64.dmg in the Downloads directory to start the installation.

4. Select "Legacy password encryption" to avoid trouble using the new password encryption method.

5. Set the root password to "DontTellAnyOne", and follow instructions to finish.

6. Verify the MySQL server daemon with the "ps" command:

herong$ ps -ef | grep mysqld
   74 94827     1   0  9:35PM 0:01.73 /usr/local/mysql/bin/mysqld \
   --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data \
   --plugin-dir=/usr/local/mysql/lib/plugin --user=_mysql \
   --log-error=/usr/local/mysql/data/mysqld.local.err \
   --pid-file=/usr/local/mysql/data/mysqld.local.pid \
   --keyring-file-data=/usr/local/mysql/keyring/keyring \
   --early-plugin-load=keyring_file=keyring_file.so \
   --default_authentication_plugin=mysql_native_password

7. Connect to the MySQL server with the "mysql" client program:

herong$ /usr/local/mysql/bin/mysql -u root -p
   Enter password: DontTellAnyOne

 mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)