Linux
版本:ubuntu 20.04.1
Linux下载网址:https://www.linux.org/pages/download/
ubuntu下载网址:https://ubuntu.com/download
选择Ubuntu desktop或Ubuntu Server都可以,这里我使用的是Ubuntu Server。
安装源
wget https://repo.zabbix.com/zabbix/5.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_5.0-1+focal_all.deb
dpkg -i zabbix-release_5.0-1+focal_all.deb
apt update
安装zabbix相关包
apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-agent
安装mysql
apt install -y mysql-server
MySQL
版本:8.0.21
mysql查看和修改密码策略
8.X版本:
#查看密码策略
show variables like ‘%validate_password.policy%’;
show variables like ‘%validate_password.length%’;
#修改密码策略
set global validate_password.policy=0; #设置为弱口令
set global validate_password.length=1; #密码最小长度为1
更新权限:
flush privileges;
修改root用户密码
一、使用命令查看mysql数据库自动设置的随机账户与密码
sudo cat /etc/mysql/debian.cnf
zabbix@zabbix:~$ sudo cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = TwP8OzZJLqw4Vtdf
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = TwP8OzZJLqw4Vtdf
socket = /var/run/mysqld/mysqld.sock
图中显示的就是默认随机的账户与密码,我们可以使用这组账号与面进行mysql登录
zabbix@zabbix:~$ mysql -udebian-sys-maint -pTwP8OzZJLqw4Vtdf
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)
二、修改root用户密码
MySql 从8.0开始修改密码有了变化,在user表加了字段authentication_string,修改密码前先检查root用户的authentication_string是否为空
mysql> select user,host,authentication_string from mysql.user;
如果不为空,先置空字段在修改密码
use mysql;
update user set authentication_string='' where user='root'; --将字段置为空
alter user 'root'@'localhost' identified with mysql_native_password by 'zabbix';
--修改密码为zabbix
如果为空,则直接修改密码
alter user 'root'@'localhost' identified with mysql_native_password by 'zabbix';
--修改密码为zabbix
更新权限或重启mysql
mysql> flush privileges; --刷新权限
zabbix@zabbix:~$ service mysql restart --重启
登陆成功
zabbix@zabbix:~$ mysql -uroot -pzabbix
.Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu)
初始化数据库
zabbix@zabbix:~$ mysql_secure_installation
Securing the MySQL server deployment.
Enter password for user root: --输入root用户密码
Estimated strength of the password: 25
Change the password for root ? ((Press y|Y for Yes, any other key for No) : n
Remove anonymous users? (Press y|Y for Yes, any other key for No) : y --询问是否移除默认的匿名用户,选择是
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n --询问是否禁止root用户远程登陆,选择否(即允许远程登陆,zabbix要用远程登陆,如果选择是,就只能本地访问)
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
-- 是否移除test这个数据库?(这个数据库只是用来测试的,可以移除)
Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y
--是否重新加载权限表?(即刷新权限)
Success.
All done! --完成初始化数据库
创建zabbix用户并授权
zabbix@zabbix:~$ mysql -uroot -pzabbix
mysql> show variables like 'character%'; --查看数据库的编码方式。或show variables like 'collation%';
mysql> create database zabbix character set utf8 collate utf8_bin;
Query OK, 1 row affected, 2 warnings (0.01 sec)
--创建新的数据库,命名为:zabbix,编码方式为utf8
mysql> show databases; //查看数据库
+--------------------+
| Database |
+------