Mysql8.0.2.19安装+oraclelinux8

一.卸载系统自带的mariadb

rpm -qa | grep mariadb (查看mariadb安装包)
rpm -e mariadb-libs-5.5.65-1.el7.x86_64 --nodeps （卸载mariadb）

二.上传mysql8.0安装包，并解压

1 cd /usr/local/ 目录下新建mysql文件夹（local目录是存放一些本地共享资源的）
2 解压mysql安装

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

3.依次按顺序安装 (common-llibs-client-server)

rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64  --nodeps --force 
rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm --nodeps --force 
rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm --nodeps --force 
rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm --nodeps --force

4.查看mysql的安装包

 rpm -qa | grep mysql

三.对MySQL数据库进行初始化相关配置

 mysqld --initialize    
chown mysql:mysql  /var/lib/mysql -R
systemctl start mysqld    
systemctl enable mysqld    
cat /var/log/mysqld.log  | grep password   

（查看自动生成的数据库密码）

mysql -uroot -p
use mysql登录mysql数据库

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

修改默认密码为root

通过以下命令，设置远程授权访问。

create user 'root'@'%' identified with mysql_native_password by 'root';
update user set host '%' where user='root';    --RROR 1410 (42000)
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

#mysql8.0加密规则修改

 alter user 'root'@'localhost' identified by 'root' password expire never;
 flush privileges;
select version()