MariaDB允许远程连接 ╰+哭是因爲堅強的太久メ 2023-01-03 14:22 183阅读 0赞 **一、数据库操作** 连接数据库 \[root@app bin\]\# ./mysql -u root -p 授权并刷新权限 grant all privileges on \*.\* to 'root'@'%' identified by 'password' with grant option; flush privileges; 查看用户数据 use mysql select user, password, host from user; **二、防护墙操作** CentOS 7关闭防火墙 [https://blog.csdn.net/haveqing/article/details/112376378][https_blog.csdn.net_haveqing_article_details_112376378] 注意别忘了关闭**iptables** **三、安全组设置规则** 如果是阿里云ECS服务器,安全组设置规则,入方向添加3306 ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hhdmVxaW5n_size_16_color_FFFFFF_t_70][] 安全组规则,一般及时生效 [https_blog.csdn.net_haveqing_article_details_112376378]: https://blog.csdn.net/haveqing/article/details/112376378 [watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hhdmVxaW5n_size_16_color_FFFFFF_t_70]: /images/20221119/757097863efb483988442e06c4e76166.png
还没有评论,来说两句吧...