Mysql 二进制包安装

1、上传二进制文件包

 

[root@DB02_52 /application]# ls
mysql-5.7.20-linux-glibc2.12-x86_64.tar
[root@DB02_52 /application]# 

2、解包及解压缩

 

[root@DB02_52 /application]# tar xf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz 
[root@DB02_52 /application]# ls
mysql-5.7.20-linux-glibc2.12-x86_64
mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz
[root@DB02_52 /application]# mv mysql-5.7.20-linux-glibc2.12-x86_64 mysql
[root@DB02_52 /application]# ls
mysql  mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

3、创建数据库所需用户

 

[root@DB02_52 /application/mysql]# useradd -s /sbin/nologin mysql
[root@DB02_52 /application/mysql]#

4、创建数据库目录并授权

 

[root@DB02_52 /application/mysql]# mkdir /data/mysql/data -p
[root@DB02_52 /application/mysql]# tree /data/
/data/
└── mysql
    └── data

2 directories, 0 files
[root@DB02_52 /application/mysql]# 
[root@DB02_52 /application/mysql]# chown -R mysql.mysql /data/
[root@DB02_52 /application/mysql]# ll /data/
total 0
drwxr-xr-x. 3 mysql mysql 18 Jun  2 11:10 mysql
[root@DB02_52 /application/mysql]# 

5、添加环境变量,并且重读生效

 

[root@DB02_52 /application/mysql]# tail -n 1 /etc/profile
export PATH=/application/mysql/bin:$PATH
[root@DB02_52 /application/mysql]# source /etc/profile
[root@DB02_52 /application/mysql]# 

6、安装开发环境包（libaio-devel)

 

[root@DB02_52 /application/mysql]# yum install libaio-devel -y

7、初始化数据

 

[root@DB02_52 /application/mysql]# mysqld --initialize-insecure --user=mysql --basedir=/application/mysql --datadir=/data/mysql/data

8、准备配置文件

 

[root@DB02_52 /data/mysql]# cat /etc/my.cnf 
[mysqld]
basedir=/application/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log_error=/data/mysql/mysql.log
server_id=6
port=3306
log_bin=/data/mysql/mysql-bin
user=mysql
skip_name_resolve
[mysql]
socket=/tmp/mysql.sock
[root@DB02_52 /data/mysql]# 

9、创建启动脚本

 

cp /application/mysql/support-files/mysql.server  /etc/init.d/mysqld

10、启动服务

 

[root@DB02_52 /data/mysql]# /etc/init.d/mysqld start 
Starting MySQL. SUCCESS! 

 
链接：https://www.jianshu.com/p/c3600f4f87f1