MySQL部署及加固参考

*[注释] : 以下实验基于MySQL5.7.18，centos6.8

一、安装参考

1、标准用户

groupadd mysql
useradd mysql -g mysql -s /sbin/nologin

2、解压并授权

tar xf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz -C /asop/
mv  mysql-5.7.18-linux-glibc2.5-x86_64 mysql5.7.18
chown -R mysql.mysql /home/mysql 

3、创建相关目录

mkdir -p /asop/mysql5.7.18/logs/{
   sock,tmpdir,log,innodb_ts,innodb_log,undo,slowlog,binlog,relaylog} 
mkdir -p /asop/mysql5.7.18/data

4、创建链接文件

ln –s  /asop/mysql5.7.18 /usr/local/mysql

5、创建环境变量

echo 'export PATH=$PATH:/usr/local/mysql/bin/' >> /etc/profile
source  /etc/profile

6、创建配置文件

#参考配置文件
vi /etc/my.cnf
[client]
socket=/asop/mysql5.7.18/logs/sock/mysql.sock 
default-character-set = utf8
local-infile=0
[mysqld]
user=mysql
port=3307
basedir = /usr/local/mysql
character-set-server=utf8
default-storage-engine = INNODB
server-id=1
collation_server = utf8_bin
log_timestamps=SYSTEM
socket=/asop/mysql5.7.18/logs/sock/mysql.sock
pid-file=/asop/mysql5.7.18/logs/sock/mysql.pid 
datadir=/asop/mysql5.7.18/data
tmpdir=/asop/mysql5.7.18/logs/tmpdir
log-error=/asop/mysql5.7.18/logs/log/error.log
slow_query_log = on
long_query_time