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

This article mainly introduces centos6 how to install MySQL5.7, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Centos6 install MySQL5.7

Install MySQL5.7 version based on centos6

There are detailed manuals to install MySQL on the official website of MySQL. This time, yum is used for installation.

1. Download the yum source for MySQL

Upload to the server for local installation

Yum localinstall mysql80-community-release-el6-3.noarch.rpm

two。 Change the pre-installed version of MySQL in the MySQLyum source

The mysql8.0 version is installed by default. Check the pre-installed version.

Yum repolist enabled | grep "mysql.*-community.*"

Change the pre-installed version to version 5.7

Yum-config-manager-disable mysql80-community

Yum-config-manager-enable mysql57-community

Yum repolist enabled | grep "mysql.*-community.*"

Change succeeded

3. To install MySQL

Yum install mysql-community-server

When prompted successfully, start the service

Service mysqld start # start the MySQL service

Service mysqld status # View MySQL service status

Service mysqld stop # stop the MySQL service

Service mysqld restart # restart the MySQL service

4. Change the MySQL default random password

MySQL generates random passwords by default. Check random passwords.

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

Log in to MySQL

Mysql-uroot-p

To change your password, it is best to use password rules to set your password

Mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' password'

Mysql > quit; # exit

Log in to mysql again. Login is successful and installation is complete.

Thank you for reading this article carefully. I hope the article "how to install centos6 MySQL5.7" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.