ERROR 1524 (HY000): Plugin ‘xyz’ is not loaded while creating user in mysql
ERROR 1524 (HY000): Plugin ‘xyz’ is not loaded while creating user in mysql
To solve this error run the following command:
mysql_upgrade -u root -p
Still if the issue doesn’t get resolved check if you are running the CREATE USER command with “WITH” or “BY“.
mysql> CREATE USER 'myuser'@'localhost' IDENTIFIED WITH 'xyz';
ERROR 1524 (HY000): Plugin 'xyz' is not loaded
If you are using “WITH“, replace it to “BY“
mysql> CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'xyz';
Query OK, 0 rows affected (0.00 sec)