二进制格式安装MySQL5.7

---

一. 安装步骤

---

1.下载二进制格式的mysql安装包

[root@node1 ~]# cd /usr/src
[root@node1 src]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz

2.创建用户和组

[root@node1 src]# useradd -r -M -s /sbin/nologin -u 306 mysql
[root@node1 src]# id mysql
uid=306(mysql) gid=306(mysql) groups=306(mysql)

3.将压缩包解压至/usr/local目录中

[root@node1 src]# tar xf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz -C /usr/local
[root@node1 src]# cd /usr/local/
[root@node1 local]# ls
bin    include  libexec                              share
etc    lib      mysql-5.7.30-linux-glibc2.12-x86_64  src
games  lib64    sbin

4.创建软链接

[root@node1 local]# ln -sv mysql-5.7.30-linux-glibc2.12-x86_64/ mysql
‘mysql’ -> ‘mysql-5.7.30-linux-glibc2.12-x86_64/’

5.修改/usr/local/mysql目录的属主和属组

[root@node1 local]# chown -R mysql.mysql /usr/local/mysql
[root@node1 local]# ll -d /usr/local/mysql
lrwxrwxrwx. 1 mysql mysql 36 Jun 10 21:13 /usr/local/mysql -> mysql-5.7.30-linux-glibc2.12-x86_64/

6.添加环境变量

[root@node1 local]# vi /etc/profile.d/mysql.sh
export PATH=/usr/local/mysql/bin:$PATH   //添加此行内容 
[root@node1 local]# source /etc/profile.d/mysql.sh 
[root@node1 local]# echo $PATH
/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

7.建立数据库存放目录

[root@node1 local]# mkdir /opt/data
[root@node1 local]# chown -R mysql.mysql /opt/data