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

First, it will introduce how to

(1) mysql5.7 has a default password

Find the default password

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

(2) sign in for the first time

Mysql-uroot-p

(3) Note: the password must be changed after the first entry, otherwise the operation cannot be carried out, otherwise an error will be reported.

To change a password, there is a default password strength: 1. At least 8 characters 2. Contains uppercase and lowercase letters 3. Have punctuation marks.

(4) change the password and exit (pay attention to the password requirements)

(5) re-login with a new password can be checked and other operations can be carried out. If you feel that the password is complex, you can change the password strength.

View password rules: SHOW VARIABLES LIKE 'validate_password%'

(6) explain the meaning of the above table

1. Whether validate_password_check_user_name compares the password with the username portion of a valid user account for the current session, and rejects it if it matches. By default, it is disabled. This variable controls that the user name matches the independent value validate_password_policy. (no need to change)

2. Validate_password_dictionary_file specifies the file path for password verification

3. Minimum length of validate_password_length password (at least 4)

4. The validate_password_mixed_case_count password should contain at least the number of lowercase letters and uppercase letters.

5. At least the number of digits that the validate_password_number_count password must contain

6. Validate_password_policy password strength level

Note: LOW (0): check only the length

MEDIUM (1): check length, number, case of letters, number of special characters

STRONG (2): check length, numbers, case of letters, number of special characters, dictionary files

7. At least the number of special characters that a validate_password_special_char_count password must contain

(7) No matter creating a user or changing a password, an error will be reported as long as the password does not comply with the rules

(8) set password strength

Set global validate_password_policy=0;set global validate_password_length=4

View password strength specification: SHOW VARIABLES LIKE 'validate_password%'

(9) now to create a user, you only need to satisfy 4 characters to change the password, which is not so complicated.

Summary

The above is the quick solution to the first login failure of mysql5.7.20 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply you in time. Thank you very much for your support to the website!

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.