mysql> create database zabbix character set utf8;
Query OK, 1 row affected (0.08 sec)
mysql> grant all privileges on *.* to 'zabbix'@'%' identified by 'zishang77';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
因本文使用的是mysql5.7,MySQL默认开启了validate_password插件,进行密码验证,需要很强的密码强度才能通过认证此版本对密码的要求比较严格,本文做了如下调整
查阅官方文档后发现有以下三种密码策略:
Policy
Tests Performed
0 or LOW
Length
1 or MEDIUM
Length; numeric, lowercase/uppercase, and special characters
2 or STRONG
Length; numeric, lowercase/uppercase, and special characters; dictionary file
mysql> select @@validate_password_policy;
+----------------------------+
| @@validate_password_policy |
+----------------------------+
| MEDIUM |
+----------------------------+
1 row in set (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.08 sec)
mysql> set global validate_password_policy=0;#设置密码的策略为low
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_mixed_case_count=0#设置指定了密码中大小字母的长度
-> ;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_number_count=2;#设置指定了密码中数据的长度
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_special_char_count=0;#设置密码中的特殊字符为0
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=6;#设置密码长度为6
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to 'zabbix'@'%' identified by 'zabbix';
Query OK, 0 rows affected, 1 warning (0.06 sec)
3.5、安装zabbix,并导入zabbix包中的数据到mysql的zabbix数据库中
[root@server134 mnt]# tar zxvf zabbix-2.4.8.tar.gz
[root@server134 mnt]# cd zabbix-2.4.8
[root@server134 mnt]# cd zabbix-2.4.8
[root@server134 zabbix-2.4.8]# mysql -uzabbix -pzabbix zabbix