mysql8.0my.cnf设置

[client] port = 3306 socket = /usr/local/lnmp/mysql-8.0.12/mysql.sock [mysqld] #设置mysql 8.0 的加密方式为 mysql_native_password (默认为:caching_sha2_password) default_authentication_plugin=mysql_native_password basedir = /usr/local/lnmp/mysql-8.0.12 datadir = /usr/local/lnmp/mysql-8.0.12/data port = 3306 server_id = 1 socket = /usr/local/lnmp/mysql-8.0.12/mysql.sock #二进制日志目录 log-bin = /usr/local/lnmp/mysql-8.0.12/mysql-bin #自动删除过期日志的天数 expire_logs_days = 10 #限制单个文件大小 max_binlog_size = 100M #查询日志 general_log = 1 #查询日志文件位置 general_log_file = /usr/local/lnmp/mysql-8.0.12/query.log #慢查询日志 slow_query_log = 1 #慢日志文件位置 slow_query_log_file = /usr/local/lnmp/mysql-8.0.12/slow-query.log #超过2秒记录 long_query_time = 2 #错误日志 log-error = /usr/local/lnmp/mysql-8.0.12/error.log sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES