MySQL Forums
Forum List  »  Install & Repo

Re: Finding root password on new 5.7 install
Posted by: Peter Brawley
Date: May 05, 2020 10:20AM

> ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded

Which tells you that mysql.user.plugin='auth_socket' for this user.

As the article cited above indicates. that plugin is designed to work only with no password. (Not a good idea but that's another story.)

So you'll need to set plugin='mysql_native_password' for that user. Or ...

alter user 'root'
IDENTIFIED WITH mysql_native_password BY 'new_pwd';

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.