mysql 修改 root 密码

5.76中加了一些passwd的策略

MySQL's validate_password plugin is installed by default. This will require that passwords contain at least one upper case letter, one lower case letter, one digit, and one special character, and that the total password length is at least 8 characters.

 

修改passwd

 

获取临时password

[root@own ~]# grep 'temporary password' /var/log/mysqld.log

2017-09-19T10:41:04.391873Z 1 [Note] A temporary password is generated for root@localhost: gyqfjhKrB7,o

 

修改passwd policy

 

[root@own ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.7.19

 

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Test@123';

Query OK, 0 rows affected (0.00 sec)

 

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.03 sec)

 

mysql> SET GLOBAL  validate_password_policy='LOW';

Query OK, 0 rows affected (0.00 sec)

 

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            | LOW  |

| validate_password_special_char_count | 1    |

+--------------------------------------+-------+

7 rows in set (0.00 sec)

 

mysql> set GLOBAL validate_password_length=6;

Query OK, 0 rows affected (0.00 sec)

 

mysql> SHOW VARIABLES LIKE 'validate_password%';

+--------------------------------------+-------+

| Variable_name                        | Value |

+--------------------------------------+-------+

| validate_password_check_user_name    | OFF  |

| validate_password_dictionary_file    |      |

| validate_password_length            | 6    |

| validate_password_mixed_case_count  | 1    |

| validate_password_number_count      | 1    |

| validate_password_policy            | LOW  |

| validate_password_special_char_count | 1    |

+--------------------------------------+-------+

7 rows in set (0.00 sec)

 

mysql> set GLOBAL validate_password_mixed_case_count=0;

Query OK, 0 rows affected (0.00 sec)

 

mysql> set GLOBAL validate_password_number_count=0;

Query OK, 0 rows affected (0.00 sec)

 

mysql> set GLOBAL validate_password_special_char_count=0;

Query OK, 0 rows affected (0.00 sec)

 

mysql> set GLOBAL validate_password_length=0;

Query OK, 0 rows affected (0.00 sec)

 

mysql> SHOW VARIABLES LIKE 'validate_password%';

+--------------------------------------+-------+

| Variable_name                        | Value |

+--------------------------------------+-------+

| validate_password_check_user_name    | OFF  |

| validate_password_dictionary_file    |      |

| validate_password_length            | 0    |

| validate_password_mixed_case_count  | 0    |

| validate_password_number_count      | 0    |

| validate_password_policy            | LOW  |

| validate_password_special_char_count | 0    |

+--------------------------------------+-------+

7 rows in set (0.00 sec)

 

修改passwd为空

 

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '';

Query OK, 0 rows affected (0.00 sec)

 

mysql>

mysql> quit

Bye

 

验证

[root@own ~]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 10

Server version: 5.7.19 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> quit

Bye

 

[root@own ~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 11

Server version: 5.7.19 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> quit

Bye

 

on mac 

 

 

     shell> cd /usr/local/mysql

     shell> sudo ./bin/mysqld_safe

     (ENTER YOUR PASSWORD, IF NECESSARY)

     (PRESS CONTROL-Z)

     shell> bg

     (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)

 

You should be able to connect to the MySQL server, for example, by

running `/usr/local/mysql/bin/mysql -uroot'.