Detailed instructions for installing mysql5.7 database under centos7.2

The mysql on the server is installed with version 8.0.12, and the local one is version 5.7. Today I deleted the 5.7 version and reinstalled it. Below are all the commands to follow and it will be installed.

Configuration Source

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm
# yum repolist enabled | grep "mysql.*-community.*"

Install:

yum install mysql-community-server

Start mysql

systemctl start mysqld

Automatic startup

systemctl enable mysqld
systemctl daemon-reload

Get the initial password

grep 'temporary password' /var/log/mysqld.log
UjmO#ZA9nt,Y

Change the root password (need to log in to mysql)

mysql -u root -p
set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'admin';

Authorize other accounts to log in remotely

CREATE USER 'admin'@'%' IDENTIFIED BY 'admin';
GRANT ALL ON *.* TO 'admin'@'%';
flush privileges

Summarize

The above is the detailed command for installing mysql5.7 database under centos7.2 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!