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