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进行处理即可