http://blog.neten.de/posts/2014/01/27/install-mysql-using-homebrew/

$ unset TMPDIR

$ mysql_install_db –verbose –user=whoami –basedir=”$(brew –prefix mysql)” –datadir=/usr/local/var/mysql –tmpdir=/tmp

Commands

```shell script brew install mysql@5.6 cd /usr/local/Cellar/mysql@5.6/5.6.51/bin ./mysqld –initialize –explicit_defaults_for_timestamp mysql.server start # no sudo! mysql -h localhost -u root -p

```shell
mysql> show databases;
mysql> use a_database_name; # switch to a db.
mysql> show tables;
mysql> SHOW PROCESSLIST; 

Backup and restore

https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html

Backup database

```shell script mysqldump –user root project_development > project_development_20200725.sql # This sql won’t contain CREATE DATABASE project_development mysqldump –databases project_development –user root > project_development_20200725.sql # This sql will contain CREATE DATABASE project_development

## Restore database
```shell script
mysql -u root -p project_development < project_development_20200725.sql
or
mysqladmin --user=root create project_development # Needn't create database if you use the `mysqldump --databases` way to backup database.

Troubleshooting

For error ERROR! The server quit without updating PID file, refer to https://stackoverflow.com/a/36156848/639040 .
For mysql2 native extension, refer to https://github.com/brianmario/mysql2/issues/1175 .