centos安装mysql8

查找卸载，自带的mariadb

查找：

1.rpm -qa | grep mysql
2.rpm -qa | grep mariadb

卸载：

1.rpm -e postfix
2.rpm -e mariadb-libs

下载安装包

下载地址
需要的包有：

1. mysql-community-server-8.0.28-1.el8.x86_64.rpm
2. mysql-community-libs-8.0.28-1.el8.x86_64.rpm
3. mysql-community-icu-data-files-8.0.28-1.el8.x86_64.rpm
4. mysql-community-common-8.0.28-1.el8.x86_64.rpm
5. mysql-community-client-plugins-8.0.28-1.el8.x86_64.rpm
6. mysql-community-client-8.0.28-1.el8.x86_64.rpm

安装

逐个安装直到把每个包都安装一次
rpm -ivh xxxx

启动服务

systemctl start mysqld

获取随机密码

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

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
如果报错，说明密码太短， MySQL没有认证成功，可以修改 认证规则：
mysql8之前

set global validate_password_policy=0; 
set global validate_password_length=1; 

mysql8

set global validate_password.policy=0; 
set global validate_password.length=1; 

开启远程访问

CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';

GRANT ALL ON *.* TO 'root'@'%';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

FLUSH PRIVILEGES;

还需要看看云服务器的防火墙是否开发了3306端口