MySQL Forums
Forum List  »  Security

Re: ALTER USER mysql_native_password
Posted by: Anthony Yates
Date: June 03, 2019 11:49AM

Found the problem.
The correct command is: ALTER USER 'bn_wordpress'@'%' IDENTIFIED WITH mysql_native_password BY ''.
You can just run the IDENTIFIED WITH part, but then you get an error that the password has expired. This is resolved by adding the BY part.

Options: ReplyQuote

Written By
June 02, 2019 12:02PM
Re: ALTER USER mysql_native_password
June 03, 2019 11:49AM

Sorry, you can't reply to this topic. It has been closed.

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.