CentOS 7.6 installation of MySQL 5.7 GA version tutorial diagram

Environment Preparation

Uninstall mariadb

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

CentOS 7.6 has mariadb integrated inside, and installing mysql will conflict with mariadb files, so you need to uninstall mariadb first.

Install MySQL

Get the yum source (MySQL official website)

Install yum source

rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Check the startup status of each version

yum repolist all | grep mysql

The latest version 8.0 is enabled by default

Disable 8.0 and enable 5.7

yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community

The command is in the yum-utils package. Installing it can solve the problem of not being able to find the yum-config-manager command:

yum -y install yum-utils

Install mysqll

yum -y install mysql-community-server

Configure MySQL remote connection

Check the MySQL version

mysql -V

Start mysql && set it to start automatically

systemctl start mysqld
systemctl enable mysqld

View the default generated password

grep 'temporary password' /var/log/mysqld.log

Login to change password

mysql -uroot -p

Change Password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NoPassword564925080!';

MySQL 5.7 has a password security check plug-in (validate_password) installed by default. The default password check policy requires that the password must contain uppercase and lowercase letters, numbers, and special symbols, and the length must not be less than 8 characters. Otherwise, the error message ERROR 1819 (HY000): Your password does not satisfy the current policy requirements will be displayed.

Authorize remote login users

GRANT ALL PRIVILEGES ON *.* TO 'noneplus'@'%' IDENTIFIED BY 'Noneplus564925080!' WITH GRANT OPTION;
flush privileges;

Open server port 3306

remote connection

Summarize

The above is the tutorial illustration of installing MySQL 5.7 GA version on CentOS 7.6 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!