Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to change the root password of mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Mysql > alter user 'root'@'localhost' IDENTIFIED BY' nancy'

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Mysql > SHOW VARIABLES LIKE 'validate_password%'

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

-modify password policy password length

Mysql > set global validate_password_policy=0

Query OK, 0 rows affected (0.00 sec)

Mysql > set global validate_password_length=4

Query OK, 0 rows affected (0.00 sec)

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' nancy'

Query OK, 0 rows affected (0.01 sec)

This is the end of the content of "how to change the root password of mysql". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.