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

Linux how to check the mysql password, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

I believe that many friends have experienced forgetting their passwords. What if they forget their MySQL passwords under Linux?

Linux how to check the mysql password.

View default password

Grep 'temporary password' / var/log/mysqld.log or

Cat / var/log/mysqld.log | grep 'temporary password' [root@VM_0_11_centos ~] # grep' temporary password' / var/log/mysqld.log 2020-05-07T16:57:52.623306Z 1 [Note] A temporary password is generated for root@localhost: Ukyool6&htfu when modifying a password for the first time, it should be noted that the password should contain letters, numbers and special characters (large and small letters and a length of not less than 8)

[root@VM_0_11_centos] # mysql-uroot-p Enter password: Welcome to the MySQL monitor. Commands end with; or\ g. Your MySQL connection id is 1721 Server version: 5.7.30 MySQL Community Server (GPL) Copyright (c) 2000, 2020, 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 > show databases; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. Mysql > alter user root@localhost identified by'rootworthy seeds 123; 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. Mysql > alter user root@localhost identified by'Rootless trees 123mm; 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.01sec) mysql > use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with-A Database changed mysql > select Host,User from user +-+-+ | Host | User | +-+-+ | localhost | mysql.session | | localhost | mysql.sys | | localhost | root | +-- -- + 3 rows in set (0.00 sec) mysql > about parameters related to mysql password policy

1), the total length of the validate_password_length fixed password

2), validate_password_dictionary_file specifies the file path for password verification

3), validate_password_mixed_case_count, the whole password should contain at least the total number of uppercase / lowercase letters

4), validate_password_number_count the whole password should contain at least the number of Arabic numerals

5). Validate_password_policy specifies the strength verification level of the password. The default is MEDIUM.

About the value of validate_password_policy:

0/LOW: only validate length

1/MEDIUM: verify length, numbers, case, special characters

2/STRONG: verify length, numbers, case, special characters, dictionary files

6), validate_password_special_char_count, the whole password must contain at least the number of special characters

After reading the above, have you mastered how Linux can check the mysql password? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.