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

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


This entry was posted in Linux, PHP, 数据库 and tagged . Bookmark the permalink.
月小升QQ 2651044202, 技术交流QQ群 178491360
首发地址:月小升博客https://java-er.com/blog/ispconfig-mysql-install/
无特殊说明,文章均为月小升原创,欢迎转载,转载请注明本文地址,谢谢
您的评论是我写作的动力.
2020.03.24 评论已经全局关闭,有事加QQ聊天