On Tue, Mar 30, 2021 at 10:23 AM Elias Holzmann
<elias.holzmann(a)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