Tutorial diagram of installing mysql8.0.18 under linux (Centos7)

cd /usr/local
mkdir mysql

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

rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64 --nodeps

mysql-community-common-8.0.15-1.el7.x86_64.rpm,
mysql-community-libs-8.0.18-1.el7.x86_64.rpm
mysql-community-client-8.0.18-1.el7.x86_64.rpm
mysql-community-server-8.0.18-1.el7.x86_64.rpm

rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm 
 rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
 rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm
 rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm

rpm -qa | grep mysql 

mysqld --initialize Initialize chown mysql:mysql /var/lib/mysql -R Authorize systemctl start mysqld Start mysql service systemctl status mysqld View mysql status cat /var/log/mysqld.log | grep password View root initial password 

mysql -u root -p #After pressing Enter, enter the initial password, which is Iv7fjuP,ucH+ (fill in your own password)

ALTER USER "root"@"localhost" IDENTIFIED BY "your own password";
FLUSH PRIVILEGES; #Effective immediately 

use mysql;
update user set host = '%' where user = 'root'; 
ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #Change the encryption method ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your own password'; #Update the user password (here I am root)