问题描述
如屏幕截图所示，我已将帐户设置为允许远程连接，但如第二个屏幕截图所示，我仍然无法远程连接.
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 不允许远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！