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

Mysql on the server installed a version 8.0.12, the local version is a version 5.7, today removed the reinstallation of version 5.7, the following are all the name commands will be installed.

Configure sourc

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

Installation:

Yum install mysql-community-server

Start mysql

Systemctl start mysqld

Self-booting

Systemctl enable mysqldsystemctl daemon-reload

Get the initial password

Grep 'temporary password' / var/log/mysqld.logUjmO#ZA9nt,Y

Change the root password (login to mysql is required)

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

Authorize remote login of other accounts

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

Summary

The above is the detailed explanation of the command to install mysql5.7 database under centos7.2 introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

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.