MySQL Installation

CLI Tips

bash CLI

# start
mysql.server start

# login
mysql -u root -p
mysql -u $user_name -p

# status
systemctl status mysql.service

# run sql script
source $sql_path

MySQL CLI

# create database
create database test character set utf8mb4;
create database $database_name character set utf8mb4;

# show
show databases;
show tables;

mycli

Reference

  1. Mac 上安装 MySQL

  2. mycli，一款让你忘记mysql-client的命令行客户端神器