centos7安装mysql5.6并开启远程访问

rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

5.7的源：http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

yum install mysql-community-server

systemctl start mysqld

systemctl status mysqld

可以看到设置默认密码的几种方式

/usr/bin/mysqladmin -u root password 'new-password'

systemctl enable mysqld

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> grant all privileges on . to root@'%' identified by "password";

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

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

firewall-cmd --reload