二、Mac 下Mysql 操作

1.启动、关闭、重启命令

##启动MySQL服务
sudo /usr/local/MySQL/support-files/mysql.server start

##停止MySQL服务
sudo /usr/local/mysql/support-files/mysql.server stop

##重启MySQL服务
sudo /usr/local/mysql/support-files/mysql.server restart

2.忘记密码后重置密码

mysql版本：8.0.11 MySQL Community Server

## 1.关闭mysql服务
sudo /usr/local/mysql/support-files/mysql.server stop 或者系统偏好里有个 MySQL 里关闭

## 2.到mysql目录
cd /usr/local/mysql/bin

## 3.获取root权限
sudo su

## 4.重启mysql服务
./mysqld_safe --skip-grant-tables &

## 5.终端进入mysql服务 （密码随便输入即可）
mysql -uroot -p 

## 6.获取修改密码权限
flush privileges;

## 7.修改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';