On Tue, Mar 30, 2021 at 10:23 AM Elias Holzmann
<[email protected]> 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

Reply via email to