Saturday 22 October 2016

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)

0 comments:

Post a Comment

 

Copyright @ 2013 Appychip.

Designed by Appychip & YouTube Channel