[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mediawiki-l
Subject:    Re: [MediaWiki-l] Problem granting privileges to mediawiki user
From:       Jeffrey Walton <noloader () gmail ! com>
Date:       2021-03-30 14:37:42
Message-ID: CAH8yC8=UUdXLfXShejhODpBHiG=a2mCW1k8vzf3jT4UmfW=vNA () mail ! gmail ! com
[Download RAW message or body]

On Tue, Mar 30, 2021 at 10:23 AM Elias Holzmann
<elias.holzmann@icloud.com> wrote:
> 
> Looks like this syntax was removed in MySQL 8.0:
> 
> "The following features related to account management have been removed:
> - ...
> - IDENTIFIED BY PASSWORD 'hash_string' syntax for CREATE USER and GRANT. Instead, \
> use IDENTIFIED WITH auth_plugin AS 'hash_string' for CREATE USER and ALTER USER, \
> where the 'hash_string' value is in a format compatible with the named plugin." 
> https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-11.html
> 
> I guess you can just remove the "IDENTIFIED BY 'password'" part from the query as \
> long as the user was already created, but I'm not really a MySQL guru, so YMMV.

Oh, thank you very much. I would not have checked a MySQL change log.

Jeff

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l


[prev in list] [next in list] [prev in thread] [next in thread]