centos7 中安装 mysql 8.x

1.下载安装包

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar

2.解压 

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

3.卸载mariodb

yum remove -y *mariadb

 

4.依次安装

        libs，client，common，server4个包 

        yum -y install mysql-community-common-8.0.33-1.el7.x86_64.rpm

        yum install mysql-community-client-8.0.33-1.el7.x86_64.rpm 

        yum install mysql-community-libs-8.0.33-1.el7.x86_64.rpm

         yum install -y mysql-community-server-8.0.33-1.el7.x86_64.rpm

自此mysql安装完成

5.初始化配置mysql

        mysqld -initialize

6.启动mysql服务 

 systemctl start mysqld.service

7.开机启动mysql服务

systemctl enable mysqld

8.获得初始化密码

cat /var/log/mysqld.log|grep password

初始密码为：wffkg:pe3(fP

 

9.使用初始密码登陆 

mysql -uroot -p

wffkg:pe3(fP

10.设置密码 

 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

在mysql内将密码修改为root

11.修改远程权限

 

1. create user 'root'@'%' identified with mysql_native_password by 'root';

2. grant all privileges on *.* to 'root'@'%' with grant option;

3. flush privileges