Re: Problem granting privileges to mediawiki user
Jeffrey Walton <[email protected]>
| Newsgroups | gmane.org.wikimedia.mediawiki |
|---|---|
| Message-ID | <CAH8yC8=UUdXLfXShejhODpBHiG=a2mCW1k8vzf3jT4UmfW=vNA@mail.gmail.com> |
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