安装ISPConfig 遇到的mysql密码强度问题

发表于 2020-03-25 16:15:52 by 月小升

Login in to MySQL and disable validate_password with:

UNINSTALL PLUGIN validate_password;

mysql设置密码强度，不够的时候就出现这个错误。

快速解决方案

my.cnf 底部关闭密码强度认证

validate_password=OFF

重启MYSQL，搞定

慢速解决方案

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.01 sec)

mysql> set global validate_password_length=1;
Query OK, 0 rows affected (0.03 sec)



SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| validate_password_check_user_name    | OFF   |
| validate_password_dictionary_file    |       |
| validate_password_length             | 4     |
| validate_password_mixed_case_count   | 1     |
| validate_password_number_count       | 1     |
| validate_password_policy             | LOW   |
| validate_password_special_char_count | 1     |
+--------------------------------------+-------+

查看我的版本

mysql -Version
5.7

mysql>  set global validate_password_policy=0;
mysql> set global validate_password_length=1;

3. 关闭mysqli_real_connect 错误

Warning: mysqli_real_connect(): Headers and client library minor version mismatch. Headers:50560 Library:50637 in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 86

vi /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php

第一句加上 error_reporting(0);

配置教程

How to Install and Configure ISPConfig CP on CentOS 7.x

https://www.howtoforge.com/community/threads/file-manager-in-ispconfig.59697/

https://www.howtoforge.com/tutorial/using-pydio-in-an-ispconfig-3-multiserver-installation

---

首发地址：月小升博客 – https://java-er.com/blog/ispconfig-mysql-install/
无特殊说明，文章均为月小升原创，欢迎转载，转载请注明本文地址，谢谢