How to check mysql password in Linux

I believe many friends have experienced forgetting their passwords. What should you do if you forget your MySQL password under Linux?

The specific method to view mysql password in Linux.

View the 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

Change password

When changing the password for the first time, please note that the password needs to contain letters, numbers, and special characters (must Contains large and small letters and the length cannot be 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 'root!@#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 'Root!@#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.01 sec)
 
 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 mysql password policy related parameters;

1), validate_password_length fixed the total length of the password;

2), validate_password_dictionary_file specified File path for password verification;

3), validate_password_mixed_case_count The entire password must contain at least the total number of upper/lowercase letters;

4), validate_password_number_count The entire password must contain at least Arabic numerals Number;

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 verify the length;

1/MEDIUM: Verify length, numbers, case, special characters;

2/STRONG: Verify length, numbers, case, special characters, dictionary file;

6), validate_password_special_char_count The entire password must contain at least the number of special characters;

The above is the detailed content of How to check mysql password in Linux. For more information, please follow other related articles on the PHP Chinese website!