# 文件路径: /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html
[mysqld]
datadir=/data/mysql
socket=/var/lib/mysql/mysql.sock
pid-file=/var/run/mysqld/mysqld.pid
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_file_per_table=1
log-error=/var/log/mysqld.log
max_connections=2000
max_allowed_packet=16M
max_connect_errors=400
tmp_table_size = 32M
innodb_buffer_pool_size=8G
!includedir /etc/my.cnf.d
4、启动mysql
systemctl start mysqld
systemctl enable mysqld
5、修改初始密码
# 查看初始密码cat /var/log/mysqld.log |grep'A temporary password is generate'# 设置密码
mysql -uroot -p
ALTER USER'root'@'localhost' IDENTIFIED BY 'your password';# 由于MySQL8.0 有密码验证组件,若希望设置简单的密码,需要修改服务验证条件# 密码检查等级,0/LOW、1/MEDIUM、2/STRONGset global validate_password.policy=0;# 密码的最短长度set global validate_password.length=6;# 密码至少要包含的小写字母个数和大写字母个数set global validate_password.mixed_case_count=0;
# 创建zabbix库
create database zabbix_proxy character set utf8mb4 collate utf8mb4_bin;# 创建zabbix用户
create user zabbix@localhost identified by 'Zabbix@123';# 授权
grant all privileges on zabbix_proxy .* to zabbix@localhost;# 导入初始表
mysql -uzabbix -pZabbix@123 zabbix_proxy </usr/local/zabbix/zabbix-6.0.6/database/mysql/schema.sql