mysql error：Your password has expired

Viewed 13
database mysql

error:

Error when connecting to server: Your password has expired. To log in you must change it using a client that supports expired passwords.
root81
1 Answers

Enter MySQL, set a new password, and set it to not expire:

mysql -uroot -p

SET PASSWORD = PASSWORD('root123456');

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

root81
Related Questions
mySQL RROR 2006 (HY000) at line XX MySQL server has gone away
1 answers
How to set foreign key constraints in MySQL?
1 answers
How to install Redis in Docker?
1 answers
mysql error：Your password has expired
1 answers
ERROR : MySQL server has gone away
1 answers
How to enable remote access for users in MySQL database
1 answers