Installing MySQL is the worst

mysql-troubleshooting.md

Installing MySQL is the worst

Install

Use MariaDB.

MySQL community edition had permissons issued with mysqld.

brew update
brew install mariadb

Start

mysql.server start

Console

mysql

Check if MySQL is running

Default port is 3306.

lsof -i -n -P | grep mariadb
netstat -aln | grep 3306

Create new user with full access

CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'my_password';
GRANT ALL ON my_db.* TO 'new_user'@'localhost';
FLUSH PRIVILEGES;