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

Centos7 install mysql new address

Https://blog.csdn.net/qq_30758673

Download and install mysql to uninstall the included mini library

Rpm-qa | grep mariadb | xargs rpm-e-- nodeps download yum image download source

Wget-I-c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm installation yum download source

Yum-y install mysql57-community-release-el7-10.noarch.rpm starts downloading

Yum-y install mysql-community-server configure mysql to start the MySQL service

Systemctl start mysqld.service

Set mysql self-booting

Systemctl enable mysqld.service

Log in to mysql for the first time to set the root username password and the initial password is / var/log/mysqld.log

Grep "password" / var/log/mysqld.log

Enter the initial password to enter the database

Mysql-uroot-p

Set password security level

SET global validate_password_policy=0

Set password length

Set global validate_password_length=1

Add root user

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

Set up external hosts to access the local database

GRANT ALL PRIVILEGES ON. TO 'root'@'%' IDENTIFIED BY' root' WITH GRANT OPTION

Refresh settin

Flush privileges

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.