MAC brew MySQL8遇到的问题

使用brew重新安装mysql的时候报错

ERROR! The server quit without updating PID file (......)

然后查日志发现

mysqld_safe mysqld from pid file /usr/local/mysql/data/mysql.pid ended](https://www.cnblogs.com/luihengk/p/6690224.html)

似乎是因为以前使用brew安装的mysql没有删除干净
找到以前安装的mysql 目录删除

rm -rf /usr/local/var/mysql

重新安装就好了

使用客户端登录时报错

Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found

简单粗暴直接修改root用户的加密方式

mysql> use mysql;
mysql> select user, host, plugin, authentication_string from user\G;
*************************** 4. row ***************************
                 user: root
                 host: localhost
               plugin: caching_sha2_password

# 修改加密方式
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';