CentOS服务器安装配置mysql并且远程连接数据库

 

#1.下载并安装MySQL官方的Yum Repository
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
#2.安装MySQL服务器
yum -y install mysql-community-server
#3.启动MySQL
systemctl start  mysqld.service
#查看MySQL运行状态
systemctl status mysqld.service
#4.此时MySQL已经开始正常运行，需要找出root的密码
grep "password" /var/log/mysqld.log
#5.登录mysql
mysql -uroot -p
#6.输入初始密码，此时不能做任何事情，因为MYSQL默认必须修改密码才能正常使用
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
# 这里会遇到一个问题，新密码设置过于简单会报错，可通过如下命令修改
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
#7.远程连接权限授权
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;
#8.查看是否授权情况
mysql> show grants for root;
+--------------------------------------------------------------+
| Grants for root@%                                           |
+--------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION |
+--------------------------------------------------------------+
1 row in set (0.00 sec)
#9.查看端口：对外任意IP，任意端口，找到我们自己的端口
netstat -tunlp

Proto Recv-Q Send-Q Local Address           Foreign Address     State    PID/Program name    
tcp6       0      0 :::3306                 :::*                LISTEN      1814/mysqld 

#10.防火墙开放3306端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
systemctl restart firewalld.service