Brief analysis of centos 7 mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

Baidu Cloud Disk:

Link: https://pan.baidu.com/s/1hv5rUWYK080hCuONqpSVCg Extraction code: qhgp

Installation Instructions:

https://www.jb51.net/article/138787.htm

Operation log

mkdir mysql
 40 ll
 41 cd my
 42 cd mysql/
 43 ll
 45 tar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar
 46 ll
 47 rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm --nodeps --force
 48 rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm --nodeps --force 
 49 rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm --nodeps --force
 50 rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm --nodeps --force
 51 rpm -qa | grep mysql 
 52 mysqld --initialize;
 53 chown mysql:mysql /var/lib/mysql -R;
 54 systemctl start mysqld.service;
 55 systemctl enable mysqld;
 56 cat /var/log/mysqld.log | grep password
 57 mysql -uroot -p
 58 systemctl stop firewalld.service;
 59 systemctl disable firewalld.service;
 60 systemctl mask firewalld.service;
 61 ifconfig

Use cat /var/log/mysqld.log | grep password command to view the database password.

Press Enter key to enter the database login interface through mysql -uroot -p

Change the password by ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

Exit MySQL using the exit; command, and then log in again using the new password

.Authorize remote access through the following command

create user 'root'@'%' identified with mysql_native_password by 'root';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER ;

Command to modify the encryption rules. The encryption rules of MySql 8.0 and 5.0 are different, and the current visualization tool only supports the old encryption method.

Refresh the modified permissions by using flush privileges; command

Use the following command to turn off the firewall:

systemctl stop firewalld.service;
systemctl disable firewalld.service;
systemctl mask firewalld.service;

Summarize

The above is the centos 7 mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!