mysql远程连接配置

最新推荐文章于 2024-05-12 07:57:52 发布

m0_46578370

最新推荐文章于 2024-05-12 07:57:52 发布

阅读量107

点赞数

本文链接：https://blog.csdn.net/m0_46578370/article/details/120258094

版权

笔记专栏收录该内容

18 篇文章 0 订阅

订阅专栏

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

                