MySQL修改密码

依次执行下面几步：

SHOW VARIABLES LIKE 'validate_password%';

set global validate_password_policy=0;

set global validate_password_length=4;

use mysql;

update user set authentication_string=password("新密码") where user='root';

service mysqld restart

 

下面这个玩意儿，你修改之后还会变回原样，所以，修改后立刻就改密码

mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.00 sec)