Mac 安装mysql-8.0.18-macos10.14-x86_64.dmg

1、官网下载

https://dev.mysql.com/downloads/mysql/

2、安装

一直下一步就好了

3 问题排查

问题1

 遇到 zsh: command not found: mysql 
请设置mysql环境 即在 ~/.bash_profile 中写入如下配置

export PATH=${PATH}:/usr/local/mysql/bin
mysql=/usr/local/mysql/bin/mysql
mysqladmin=/usr/local/mysql/bin/mysqladmin

然后刷新配置

source ~/.bash_profile

问题2

遇到 authentication plugin ‘caching_sha2_password’ cannot be loaded: dlopen(/usr/local/lib/plugin/cachin
错误则请先用命令行登陆root账号修改密码配置（参考3、设置）

mysql -u root -p

use  mysql;
select host,user,plugin from user;

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

FLUSH PRIVILEGES;

问题3

遇到以下问题则直接按照问题2进行处理即可

4 、重启