mysql.cnf配置文件详细介绍


加载顺序:/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf

以下是my.cnf配置文件参数解释:

[client]
port = 3306 #端口号
socket = /tmp/mysql.sock #socket所在路径
[mysqld]
!include /home/mysql/etc/mysqld.cnf #包含的配置文件 ,把用户名,密码文件单独存放
port = 3306
socket = /tmp/mysql.sock
pid-file = /home/mysql/var/mysql.pid#进程pid
basedir = /home/mysql/#mysql的安装路径
datadir = /home/mysql/var/ #数据文件所在路径
tmpdir = /home/mysql/tmp/#临时文件保存路径
slave-...


12-3 22:38 阅读:8 评论:0

顶部