MySQL8 CentOS8.3安装配置图解

1、rpm -qa |grep mariadb

2、yum -y remove mariadb*

/usr/bin/perl is needed by mysql-community-server-8.0.21-1.el8.x86_64

yum install perl.x86_64

mysqld --initialize

ll /var/lib/mysql

systemctl start mysqld

systemctl enable mysqld

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

alter user 'root'@'localhost' identified by 'rootROOT1234@';

select user,host from user;

update user set host = '%' where user = 'root';