MariaDB 不允许远程连接 [英] MariaDB not allowing remote connections

问题描述

如屏幕截图所示，我已将帐户设置为允许远程连接，但如第二个屏幕截图所示，我仍然无法远程连接.

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.

推荐答案

我用于在虚拟机(Ubuntu 16.04)中测试，对我来说，我修复了更改文件 50-server.cnf 的错误.

I use for testing in the virtual machine (Ubuntu 16.04), for me, I fixed the error changing the file 50-server.cnf.

我的服务器是 Ubuntu，所以修改下面的文件:

My server is Ubuntu, so changing the file below:

50-server.cnf

这个文件的路径:

/etc/mysql/mariadb.conf.d

PS:在更改之前创建文件的备份.

PS: Create a backup of the file before the change.

仅将文件中的 bind-address 127.0.0.0 更改为 bind-address 0.0.0.0

Only change in file the bind-address 127.0.0.0 to bind-address 0.0.0.0

在此重启服务后重试.

关于该用户，需要允许外部连接.

Regarding that user, need to allow for external connections.

希望这些信息对您有所帮助.

I hope that this info helps you.

这篇关于MariaDB 不允许远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！