在CentOS7上安装MySQL8

卸载MariaDB

命令查看 MariaDB 的安装包

1
rpm -qa | grep mariadb

卸载

1
rpm -e mariadb-libs-xxxx.x86_64 --nodeps

下载RPM包

https://dev.mysql.com/downloads/mysql/

选择Red Hat，Linux7。

安装MySQL服务

新建目录

1
2
3
cd /usr/local/ 
mkdir mysql
cd mysql

解压RPM包

1
tar -xvf mysql-xxx.x86_64.rpm-bundle.tar

安装

1
2
3
4
rpm -ivh mysql-community-common-xxxx.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-libs-xxxx.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-client-xxxx.x86_64.rpm --nodeps --force
rpm -ivh mysql-community-server-xxxx.x86_64.rpm --nodeps --force

初始化

1
2
3
4
mysqld --initialize
chown mysql:mysql /var/lib/mysql -R
systemctl start mysqld.service
systemctl enable mysqld

查看初始密码

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

进入数据库

1
mysql -uroot -pxxxx

修改密码

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

授权远程访问

1
2
3
create user 'root'@'%' identified with mysql_native_password by 'root';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;