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

Centos7 install Mysql

Wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

Rpm-ivh mysql-community-release-el7-5.noarch.rpm

Ls / etc/yum.repos.d/

Yum repolist all | grep mysql

Yum install mysql-server

Rpm-qa | grep mysql

Systemctl start mysql

Systemctl restart mysql

Systemctl stop mysql

Systemctl enable mysql

Mysql-u root

Mysql > use mysql

Mysql > update user set password=PASSWORD ("enter root user password here") where User='root'

Mysql > flush privileges

Mysql > GRANT ALL PRIVILEGES ON *. * TO root@ "%" IDENTIFIED BY "123456"

Mysql > show grants for root@'%'

Firewall-cmd-add-port=3306/tcp-permanent

Firewall-cmd-reload

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.