[mysqld] datadir=/data/mysql-data/data default_authentication_plugin=mysql_native_password #使用mysql8以前的密码插件,以便navicat等工具能够正常连接 default-storage-engine=INNODB character_set_server=utf8mb4 secure_file_priv=/var/lib/mysql [mysqld_safe] character_set_server=utf8mb4 [mysql] default-character-set=utf8mb4 [mysql.server] default-character-set=utf8mb4 [client] default-character-set=utf8mb4