自制软件，MySQL 8支持 [英] Homebrew, MySQL 8 support

问题描述

任何人都知道何时将更新Homebrew以支持MySQL 8的第一个通用发行版(8.0.11)?我似乎无法通过搜索找到它，但我敢打赌，这里的人知道:)

解决方案

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 :

三步解决方案:

1. 添加到my.cnf文件的[mysqld]部分(可在/usr/local/etc/中找到，用于Homebrew的安装):

   default-authentication-plugin=mysql_native_password
   

2. 在shell提示下:

   mysql -u root -p
   
   > ALTER USER 'root'@'localhost'
      IDENTIFIED WITH mysql_native_password
      BY '[password]';
   
   > exit
   

3. 重新启动服务器

   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:

1. Add to [mysqld] section of my.cnf file (found in /usr/local/etc/ for Homebrew's installation):

   default-authentication-plugin=mysql_native_password
   

2. At shell prompt:

   mysql -u root -p
   
   > ALTER USER 'root'@'localhost'
      IDENTIFIED WITH mysql_native_password
      BY '[password]';
   
   > exit
   

3. Reboot server

   brew services restart mysql
   

Short version solution

Long version solution

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.

这篇关于自制软件，MySQL 8支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！