MySQL:Your password does not satisfy the current policy requirements

發(fā)布時(shí)間：2020-08-09 10:40:24 來(lái)源：ITPUB博客閱讀：412 作者：甲骨文技術(shù)支持欄目：MySQL數(shù)據(jù)庫(kù)

環(huán)境：

mysql> select version();
+------------+
| version() |
+------------+
| 5.7.17-log |
+------------+
1 row in set (0.00 sec)

報(bào)錯(cuò)：

mysql> create user repl@'192.168.100.51' identified by '123456';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

出現(xiàn)這個(gè)問(wèn)題是因?yàn)榘惭b了插件，如下：

mysql> select name,dl from mysql.plugin;
+-------------------+----------------------+
| name | dl |
+-------------------+----------------------+
| validate_password | validate_password.so |
+-------------------+----------------------+
1 row in set (0.00 sec)

具體規(guī)則是：

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 |
+--------------------------------------+--------+

插件的安裝啟用：

1.插件對(duì)應(yīng)的庫(kù)對(duì)象文件需在配置選項(xiàng)plugin_dir指定的目錄中。

2.可使用--plugin-load=validate_password.so在server啟動(dòng)時(shí)載入插件，或者將plugin-load=validate_password.so寫入配置文件。

3.也可以通過(guò)如下語(yǔ)句在server運(yùn)行時(shí)載入插件（會(huì)注冊(cè)進(jìn)mysql.plugins表）mysql> INSTALL PLUGIN validate_password SONAME 'validate_password.so';

為阻止該插件在運(yùn)行時(shí)被刪除可在配置文件中添加：
[mysqld]
plugin-load=validate_password.so
validate-password=FORCE_PLUS_PERMANENT

更多信息：

https://dev.mysql.com/doc/refman/5.7/en/validate-password-plugin-installation.html

向AI問(wèn)一下細(xì)節(jié)

MySQL:Your password does not satisfy the current policy requirements

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽