Bagaimana untuk menyemak kata laluan mysql di Linux

Saya percaya ramai rakan pernah terlupa kata laluan mereka Apakah yang perlu anda lakukan jika anda terlupa kata laluan MySQL anda di bawah Linux?

Kaedah khusus untuk menyemak kata laluan mysql dalam Linux.

Lihat kata laluan lalai

grep ‘kata laluan sementara’ /var/log/mysqld.log

atau

cat / var/log/mysqld.log |. grep ‘kata laluan sementara’

 [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

Tukar kata laluan

Apabila menukar kata laluan buat kali pertama, sila ambil perhatian bahawa kata laluan perlu mengandungi huruf, nombor, dan aksara khas (mesti Mengandungi huruf besar dan kecil dan panjangnya tidak boleh kurang daripada 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>

Mengenai parameter berkaitan dasar kata laluan mysql

1), validate_password_length menetapkan jumlah panjang kata laluan ;

2), validate_password_dictionary_file ditentukan Laluan fail untuk pengesahan kata laluan; 4), validate_password_number_count Keseluruhan kata laluan mesti mengandungi sekurang-kurangnya angka Arab Nombor; :

0/RENDAH: hanya sahkan panjangnya;

1/SEDERHANA: Sahkan panjang, nombor, huruf besar, aksara khas; , kes, aksara khas, fail kamus;

6), validate_password_special_char_count Keseluruhan kata laluan mesti mengandungi sekurang-kurangnya bilangan aksara khas;

Atas ialah kandungan terperinci Bagaimana untuk menyemak kata laluan mysql di Linux. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!