3.1 Mysql
3.1.1 安装mysql
yum install -y mysql-community-server
mkdir -p /data/mysql
chown mysql.mysql /data/mysql/
touch /data/mysql/mysql_3306.error
chown mysql.mysql /data/mysql/mysql_3306.error
mysql_install_db --user=mysql --datadir=/data/mysql/data
mv /etc/my.cnf /etc/my.cnf.bak
3.1.2 修改mysql配置文件
vim /etc/my.cnf
---
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set = utf8
[mysql]
no-auto-rehash
default-character-set = utf8
[mysqld]
user = mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /data/mysql/data
default-storage-engine=INNODB
collation-server = utf8_general_ci
init-connect = 'SET NAMES utf8'
character-set-server = utf8
skip-external-locking
pid-file = /data/mysql/mysql.pid
log-bin &#