mysql 配置文件

一

[mysqld]
basedir=/usr/local/mysql/mysql-5.6.31/
datadir=/usr/local/mysql/mysql-5.6.31/data
socket=/usr/local/mysql/mysql-5.6.31/mysql.sock
user=mysql
port=3306
lower_case_table_names=1
event_scheduler=ON
character_set_server=utf8
init_connect='SET NAMES utf8'
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_file_per_table=1
wait_timeout=30
[mysqld_safe]
log-error=/usr/local/mysql/mysql-5.6.31/logs/mysqld.log
pid-file=/usr/local/mysql/mysql-5.6.31/mysqld.pid

二

[mysqld]
 basedir=/data/mysql/
 datadir=/data/mysql/data
 socket=/data/mysql/mysql.sock
 user=mysql
 port=3306
 lower_case_table_names=1
 event_scheduler=ON
 character_set_server=utf8
 init_connect='SET NAMES utf8'
 # Disabling symbolic-links is recommended to prevent assorted security risks
 symbolic-links=0
 innodb_file_per_table=1
 wait_timeout=30
 [mysqld_safe]
 log-error=/data/mysql/logs/mysqld.log
 pid-file=/data/mysql/mysqld.pid