CentOS7下安装mysql8或者mysql5.7

mysql8

---

1、下载
访问mysql官网下载mysql8软件包
https://dev.mysql.com/downloads/mysql/
选择相应的版本如：RPM Bundle mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
RPM Bundle 8.0.33 下载地址：https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

2、解压

tar -xvf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

3、安装

rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-plugins-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-icu-data-files-8.0.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm 

装到sever的时候报错net-tools没有，那装一下

yum install -y net-tools

此时报一堆镜像找不到，原因是没有配DNS

vi  /etc/resolv.conf

最后面加上nameserver XXX.XX.XX.XX，配置好你的域名服务器，保存退出，重复上面的安装过程就好了

4、初始化

mysqld --initialize --console

初始化后用命令查看日志里的密码

5、授权
修改安装目录的所有者/所属组,使用户拥有访问MySQL文件夹的权限

chown -R mysql:mysql  /var/lib/mysql

6、启动

systemctl start mysqld

7、登录

mysql -u root -p

输入刚才找到的密码，就进来了
修改成你自己的密码

ALTER USER USER() IDENTIFIED BY '密码';

8、设置服务开机自启动

systemctl enable mysqld
systemctl status mysqld

---

mysql5.7

---

5.7的安装与8稍有差别

• 1、下载mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
  解压后安装

rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm 
rpm -ivh mysql-community-devel-5.7.24-1.el7.x86_64.rpm 

• 2、启动
  启动后报错，打印日志报错

 Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4800

发现是之前装了mysql 8，遗留的/var/lib/mysql目录里的文件与5.7相冲，所以把/var/lib/mysql删掉，然后重启

systemctl start mysqld

ok，好了。

• 3、登录
  查看密码

grep 'temporary password' /var/log/mysqld.log