麒麟V10 SP3系统安装MySQL 8.0

1、删除内部冲突数据库

查看系统是否安装过MySQL和mariadb

rpm -qa | grep mariadb
rpm -qa | grep mysql

删除mariadb和MySQL

rpm -e {mariadb-server,mariadb,mariadb-errmessage,mariadb-common}
sudo yum remove mysql mysql-server

2、下载安装MySQL 8.0

创建安装目录

mkdir mysql
tar -xvf mysql-8.0.41-1.el8.x86_64.rpm-bundle.tar -C mysql/
cd mysql/
ls -lh

逐项按顺序安装

sudo rpm -ivh mysql-community-common-8.0.41-1.el8.x86_64.rpm
sudo rpm -ivh mysql-community-client-plugins-8.0.41-1.el8.x86_64.rpm
sudo rpm -ivh mysql-community-libs-8.0.41-1.el8.x86_64.rpm
sudo rpm -ivh mysql-community-client-8.0.41-1.el8.x86_64.rpm
sudo rpm -ivh mysql-community-icu-data-files-8.0.41-1.el8.x86_64.rpm
sudo rpm -ivh mysql-community-server-8.0.41-1.el8.x86_64.rpm
sudo rpm -ivh mysql-community-devel-8.0.41-1.el8.x86_64.rpm

3、开启MySQL服务

开启并查看MySQL服务状态

sudo systemctl status mysqld
sudo systemctl status mysqld

查看临时密码

sudo grep password /var/log/mysqld.log

使用临时密码登录

mysql -uroot -p

修改密码

alter user user() identified by '新密码';

开启MySQL远程登录

show databases;
use mysql;
select host,user,plugin from user;
update user set host="%" where user='root';
flush privileges;
select host,user,plugin from user;
quit

将MySQL服务设为自启动

sudo systemctl enable mysqld
sudo systemctl status mysqld