MariaDB不允许远程连接 [英] MariaDB not allowing remote connections
本文介绍了MariaDB不允许远程连接的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
如屏幕截图所示，我已将帐户设置为允许远程连接，但是如第二个屏幕截图所示，我仍然无法进行远程连接.
As the screenshots show, I have the accounts setup to allow remote connections but as shown in the second screenshot I still cannot connect remotely.
推荐答案
默认情况下，MySQL绑定到系统上的所有接口0.0.0.0.这意味着您已经可以从另一台计算机进行连接.问题可能是权限.您可以通过运行以下命令来启用远程连接:
Mysql by default binds to 0.0.0.0 which is all interfaces on your system. Which means you can already connect from another computer. The issue is perhaps permissions. You can enable remote connections by running the following command:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.%' IDENTIFIED BY '' WITH GRANT OPTION;
这篇关于MariaDB不允许远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
