linux下安装mysql 5.7和mysql8.0双版本

linux下安装mysql 5.7和mysql8.0双版本，记录一下步骤，以备所需~

一.linux下安装mysql 5.7

1.首先去官网下载好安装包放在本机目录下

2.解压安装包

[root@test ~]# cd /data/soft

[root@test soft]# ll

total 678512

-rw-r--r-- 1 root root 694785800 Sep 23 15:55 mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz

[root@test soft]# tar -zxvf  mysql-5.7.44-linux-glibc2.12-x86_64.tar.gz

[root@test soft]# mv mysql-5.7.44-linux-glibc2.12-x86_64 /usr/local/mysql

3.创建mysql用户并授权

[root@test local]# groupadd mysql

[root@test local]# useradd -r -g mysql mysql

[root@test local]# chown -R mysql mysql

[root@test local]# chgrp -R mysql mysql

[root@test local]# mkdir /var/lib/mysql

[root@test local]]# chown mysql:mysql /var/lib/mysql

4.修改配置文件

[root@test etc]# vi my.cnf

[mysqld]

basedir=/usr/local/mysql

datadir=/var/lib/mysql

socket=/tmp/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe]

log-error=/var/lib/mysql/mysql.err

#pid-file=/var/lib/mysql/mysql.pid

#character config

character_set_server=utf8mb4

#####

5.安装初始化，完成后会生成初始密码记住

[root@test etc]# cd /usr/local/mysql/bin/

[root@test bin]# ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/var/lib/mysql --user=mysql --initialize

6.安装完成启动服务

[root@test bin]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

[root@test bin]# service mysql start

Starting MySQL.Logging to '/var/lib/mysql/mysql.err'.

                                                           [  OK  ]

6.用初始密码登录后修改密码

[root@test bin]# ./mysql -uroot -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit;

[root@test local]# ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

二.mysql5.7安装配置完成后继续安装mysql8.0

[root@test soft]#tar -xvf mysql-8.0.22-linux-glibc2.12-x86_64.tar

[root@test soft]#tar -xf mysql-8.0.22-linux-glibc2.12-x86_64.tar.xz

[root@test soft]# mv mysql-8.0.22-linux-glibc2.12-x86_64 /usr/local/mysql8

[root@test local]# chown -R mysql:mysql mysql8

[root@test local]# mkdir /var/lib/mysql8

[root@test local]]# chown mysql:mysql /var/lib/mysql8

[root@test etc]# vi my8.cnf

[mysqld]

Port=3388

basedir=/usr/local/mysql8

datadir=/var/lib/mysql8

socket=/tmp/mysql8.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

[mysqld_safe]

log-error=/var/lib/mysql8/mysql.err

#

#character config

character_set_server=utf8mb4

[client]

Port=3388

character_set_server=utf8mb4

###

[root@test etc]# cd /usr/local/mysql/bin/

[root@test etc]#./mysqld --defaults-file=/etc/my8.cnf --basedir=/usr/local/mysql8 --datadir=/var/lib/mysql8 --user=mysql --initialize

#启动

[root@test ~]/usr/local/mysql8/bin/mysqld_safe  --defaults-file=/etc/my8.cnf  &

#登录

[root@test ~]# /usr/local/mysql8/bin/mysql -S /tmp/mysql8.sock -uroot -p

#停止

[root@test bin]# ./mysqladmin -uroot -p -S /tmp/mysql8.sock shutdown