[大数据]mysql远程连接配置

1. 阿里云服务器首先去网页版控制台安全组添加3306端口
2. 防火墙
   firewall-cmd --zone=public --add-port=3306/tcp --permanet
   firewall-cmd --reload
3. 进入mysql, 修改host为%或者指定ip
   update user set host=‘%‘ where user=‘username‘
4. 修改权限
   GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;
   FLUSH PRIVILEGES;
5. root账户要修改密码
   ALTER USER ‘username’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;
   注意password要数字字母等结合
   FLUSH PRIVILEGES;
6. 修改配置文件 bind_adress 127.0.0.1为0.0.0.0
7. 重启mysql service mysql restart