MySQL Forums
Forum List  »  Security

Re: ALTER USER mysql_native_password
Posted by: Georgi Kodinov
Date: June 04, 2019 05:59AM

Ok, so your user was 'bn_wordpress'@'%' and not 'bn_wordpress'@'localhost'.
Fair enough.

IDENTIFIED WITH without a password is clearly specified to set the password as expired according to https://dev.mysql.com/doc/refman/8.0/en/alter-user.html.

The rationale being that the previous contents of the authentication_string is probably not applicable to the new authentication method selected.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria

Options: ReplyQuote


Subject
Views
Written By
Posted
5836
June 02, 2019 12:02PM
Re: ALTER USER mysql_native_password
886
June 04, 2019 05:59AM


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.