MySQL-show variables like .....返回：Empty set_show variables like %datadir%回显empty set-CSDN博客

本文链接：https://blog.csdn.net/weixin_44872254/article/details/105543610

本文介绍了解决MySQL中showvariableslike...返回Emptyset的问题，通过安装validate_plugin插件并设置密码策略，包括长度、复杂度等参数，以增强数据库的安全性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MySQL-show variables like …返回：Empty set

解决办法：安装validate_plugin插件

mysql> install plugin validate_password soname 'validate_password.dll';  
Query OK, 0 rows affected (0.00 sec)   

mysql> show variables like "validate_password%";
+--------------------------------------+--------+  
| Variable_name                        | Value  |  
+--------------------------------------+--------+  
| 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      |  
+--------------------------------------+--------+  
6 rows in set (0.00 sec)  

mysql> set global validate_password_length =6;
+--------------------------------------+--------+  
| Variable_name                        | Value  |  
+--------------------------------------+--------+  
| validate_password_dictionary_file    |        |  
| validate_password_length             | 6      |  
| validate_password_mixed_case_count   | 1      |  
| validate_password_number_count       | 1      |  
| validate_password_policy             | MEDIUM |  
| validate_password_special_char_count | 1      |  
+--------------------------------------+--------+  
6 rows in set (0.00 sec)  

mysql> set global validate_password_policy = LOW;//STRONG,MEDIUM,LOW