Shulou(Shulou.com)06/01 Report--

Editor to share with you how to install MySQL 5.7GA version of CentOS7.6, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Environmental preparation

Uninstall mariadb

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

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

Install MySQL

Install the 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

Disable 8.0, turn on 5.7

Yum-config-manager-disable mysql80-communityyum-config-manager-enable mysql57-community

The command is in the yum-utils package, and installation can solve the problem that the yum-config-manager command cannot be found:

Yum- y install yum-utils

Install mysqll

Yum-y install mysql-community-server

Configure MySQL remote connection

View mysql version

Mysql-V

Start mysql&& to set boot self-boot

Systemctl start mysqldsystemctl enable mysqld

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

Log in to change the password

Mysql-uroot-p

Modify the password

ALTER USER 'root'@'localhost' IDENTIFIED BY' NoPassword 564925080'

Mysql5.7 installs the password Security check plug-in (validate_password) by default, and the default password check policy requires that passwords must contain uppercase and lowercase letters, numbers, and special symbols, and must be no less than 8 digits in length. Otherwise, ERROR 1819 (HY000): Your password does not satisfy the current policy requirements error will be prompted.

Authorize remotely logged in user

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

Open server port 3306

Remote connection

The above is all the contents of the article "how to install MySQL 5.7GA version of CentOS7.6". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.