Centos7安装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(“这里输入root用户密码”) 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
