mysql.md

mysql for macOS

Download mysql: https://dev.mysql.com/downloads/mysql/
and shell: https://dev.mysql.com/downloads/shell/

add mysql alias to .zprofile

echo 'alias mysql=/usr/local/mysql/bin/mysql' >> ~/.zprofile

login

mysql -u root -p

create user, database

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

CREATE DATABASE db_name;

use database

USE db_name;

grant all privileges

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';

show users, databases, grants

SHOW USERS;

SHOW DATABASES;

SHOW GRANTS FOR 'username'@'localhost';

remove user, database

DROP USER 'username'@'localhost';

DROP DATABASE db_name;