Install MySQL on my mac

Download and install

https://dev.mysql.com/downloads/file/?id=492745

MySQL strong password
root
Kxx

Install MySQL workbench as well.

You can create a new schema (eg, matthew_schema) in MySQL workbench. It will show as below.
Some helpful, but too long video:
https://www.youtube.com/watch?v=UcpHkYfWarM

> mysql -u root -p
xxx

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| matthew_schema     |

| mysql              |

| performance_schema |

| sys                |

+--------------------+

5 rows in set (0.00 sec)

mysql> use matthew_schema;

Start/Stop MySQL Server

https://osxdaily.com/2014/11/26/start-stop-mysql-commands-mac-os-x/

or
System preference >> MySQL

Samples

mysql> select table_schema,table_name,table_type from information_schema.tables where table_schema = 'matthew_schema' 

    -> ;

+----------------+------------+------------+

| TABLE_SCHEMA   | TABLE_NAME | TABLE_TYPE |

+----------------+------------+------------+

| matthew_schema | t_test     | BASE TABLE |

+----------------+------------+------------+

1 row in set (0.00 sec)

mysql> select table_schema,table_name,table_type from information_schema.tables where table_schema = 'matthew_schema' and table_name ='migrations' and table_type = 'BASE TABLE';