Shulou(Shulou.com)06/01 Report--

The following brings you about the expiration of mysql5.7 database users how to do the content, I believe you must have read similar articles. What's the difference between what we bring to everyone? Let's take a look at the body. I'm sure you'll get something after reading the expiration date of mysql5.7 database users.

Mysql > show slave status\ G

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Scenario: there is no problem with the use of the database. Suddenly, the developer reported that the program could not connect to the database. I went to the database server manually and found that I could log in, but could not perform any operation.

one

Solve the problem as above

Execute step2 directly if you have a password

Reason: this is the mysql5.7 password expiration policy

For the above about the expiration of mysql5.7 database users, do you think it is what you want? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.