mysql8 配置

mysql8 兼容新老版本的认证方式
default_authentication_plugin=mysql_native_password

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
server_id=31
log-error=/var/lib/mysql/error.log
log_bin=/var/lib/mysql/mysql-bin
skip_name_resolve
port=3306
character-set-server=utf8
default_authentication_plugin=mysql_native_password

[client]
default-character-set=utf8

数据库授权

create user 'zabbix'@'10.10.240.16' identified with mysql_native_password by 'zabbix';
grant all privileges on zabbix.* to 'zabbix'@'10.10.240.16';
flush privileges;