mysql5.6 install and config

1#my.cnf

[client]
port = 3306
socket = /data1/mysql/data/mysql.sock
default_character_set=utf8

[mysql]
default-character-set=utf8
socket=/data1/mysql/data/mysql.sock

[mysqld]
user = mysql
skip-name-resolve
port=3306
socket=/data1/mysql/data/mysql.sock
log_bin = mysql-bin
log-error = /data1/mysql/logs/mysql-error.log
slow-query-log = 1
slow_query_log_file = /data/mysql/logs/mysql-slow.log
basedir=/data1/mysql/mysql
datadir=/data1/mysql/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

2#init and start

mv mysql-5.6.48-linux-glibc2.12-x86_64 mysql
chown -R mysql:mysql ./
./mysql/scripts/mysql_install_db --user=mysql --basedir=/data1/mysql/mysql/ --datadir=/data1/mysql/data/
cp -a support-files/mysql.server /etc/init.d/mysqldd
/etc/init.d/mysqldd start

原文地址:https://www.cnblogs.com/gaoyanbing/p/12963286.html