Centos7安装Mysql

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