更新时间:2023-11-10 15:11:04
Homebrew昨天(2018年6月13日,星期三)将MySQL 8.0.11进行了升级.我以为我可以固定住它,但是没有这种运气.
这完全是灾难:
MySQL 8.0.11使用caching_sha2_password
作为默认的身份验证方法(将其留给Oracle在单点发行版中执行类似的操作,但是有).
到目前为止,它破坏了我尝试过的所有内容:phpMyAdmin,Nextcloud和WordPress.
今天晚些时候我将回滚至5.7.22.
更新CDT 2018年6月17日下午6:50 :
三步解决方案:
添加到my.cnf
文件的[mysqld]
部分(可在/usr/local/etc/
中找到,用于Homebrew的安装):
default-authentication-plugin=mysql_native_password
在shell提示下:
mysql -u root -p
> ALTER USER 'root'@'localhost'
IDENTIFIED WITH mysql_native_password
BY '[password]';
> exit
重新启动服务器
brew services restart mysql
短版解决方案 >
2018年6月18日CDT更新11:53 PM :
以上提供的解决方案充其量只是部分.以我的经验,MySQL 8.0.11尚未准备好用于生产(甚至开发).
Anyone have the inside scoop on when Homebrew will be updated to support MySQL 8's first general release (8.0.11)? I can't seem to find it by searching, but I bet someone here knows :)
Homebrew pushed MySQL 8.0.11 as an upgrade yesterday (Wed, 13 June 2018). I thought I had it pinned, but no such luck.
It's a total disaster:
MySQL 8.0.11 uses caching_sha2_password
as the default authentication method (leave it to Oracle to do something like this in a point release, but there you have it).
So far, it breaks everything I've tried: phpMyAdmin, Nextcloud, and WordPress.
I'll be rolling back to 5.7.22 later today.
Update 17 June 2018 6:50PM CDT:
Three step solution:
Add to [mysqld]
section of my.cnf
file (found in /usr/local/etc/
for Homebrew's installation):
default-authentication-plugin=mysql_native_password
At shell prompt:
mysql -u root -p
> ALTER USER 'root'@'localhost'
IDENTIFIED WITH mysql_native_password
BY '[password]';
> exit
Reboot server
brew services restart mysql
Update 18 June 2018 11:53PM CDT:
The solution provided above is partial, at best. In my experience MySQL 8.0.11 is not nearly ready for production (or even development) use.