MySQL配置

[mysql]
port = 3306
socket = /data/mysql/mysql.sock
default-character-set=utf8mb4


[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/data/mysql
socket=/data/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
default-storage-engine = innodb
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
innodb_autoinc_lock_mode=0
interactive_timeout=86400
wait_timeout=86400
max_connections=500
log_bin = /data/mysql/mysql-bin


[client]
default-character-set=utf8mb4


[mysqld_safe]
log-error=/data/mysql/mysqld.log

pid-file=/data/mysql/mysqld.pid

-----------------------------------------------------------

指定数据目录：

# mv /var/lib/mysql /var/lib/mysql.bak

# ln -s /data/mysql /var/lib/mysql

初始化数据库：

# mysql_install_db --datadir=/data/mysql --user=mysql