以下是MySQL my.cnf文件的常规配置:
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
datadir=/var/lib/mysql
log_error=/var/log/mysql/error.log
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
innodb_file_per_table=1
innodb_buffer_pool_size=512M
#以下是安全相关配置,根据实际情况进行调整
bind-address=127.0.0.1 #仅允许本地连接
skip-networking #禁止远程连接
#禁止root用户远程登录数据库,创建其他专门用户进行操作。
#在mysql中执行以下命令:
#CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
#GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost' WITH GRANT OPTION;
#FLUSH PRIVILEGES;
skip-name-resolve #禁用DNS解析功能,提高安全性能。




