centos7 mysql5.7 安装_Centos7 安装MySQL 5.7 (通用二进制包)

1.下载安装包

下载地址

安装文档

2.创建用户和组

groupadd mysql

useradd -g mysql -s /sbin/nologin mysql

3.解压到指定目录

tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local

cd /usr/local/

ln -s mysql-5.7.17-linux-glibc2.5-x86_64 mysql

或者

mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql

4.配置PATH

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

source /etc/profile

5.数据库目录规划

文件类型

实例3306

软链

数据datadir

/usr/local/mysql/data

/data/mysql/data

参数文件my.cnf

/usr/local/mysql/etc/my.cnf

错误日志log-error

/usr/local/mysql/log/mysql_error.log

二进制日志log-bin

/usr/local/mysql/binlogs/mysql-bin

/data/mysql/binlogs/mysql-bin

慢查询日志slow_query_log_file

/usr/local/mysql/log/mysql_slow_query.log

套接字socket文件

/usr/local/mysql/run/mysql.sock

pid文件

/usr/local/mysql/run/mysql.pid

备注：考虑到数据和二进制日志比较大，需要软链

mkdir -p /data/mysql/{data,binlogs,log,etc,run}

ln -s /data/mysql/data /usr/local/mysql/data

ln -s /data/mysql/binlogs /usr/local/mysql/binlogs

ln -s /data/mysql/log /usr/local/mysql/log

ln -s /data/mysql/etc /usr/local/mysql/etc

ln -s /data/mysql/run /usr/local/mysql/run

chown -R mysql.mysql /data/mysql/

chown -R mysql.mysql /usr/local/mysql/{data,binlogs,log,etc,run}

也可以只对数据目录和二进制日志目录软链

mkdir -p /usr/local/mysql/{log,etc,run}

mkdir -p /data/mysql/{data,binlogs}

ln -s /data/mysql/data /usr/local/mysql/data

ln -s /data/mysql/binlogs /usr/local/mysql/binlogs

chown -R mysql.mysql /usr/local/mysql/{data,binlogs,log,etc,run}

chown -R mysql.mysql /data/mysql

6.配置my.cnf参数文件

删除系统自带的my.cnf

rm -f /etc/my.cnf

在/usr/local/mysql/etc/下创建my.cnf文件，加入如下参数，其他