MySQL/MariaDB远程访问设置

版本号Debian 9的MariaDB 10.1。

进入/etc/mysql一番研究可以发现mysql-server端的配置都在/etc/mysql/mariadb.conf.d/50-server.conf里,其中有这么一行

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address           = 127.0.0.1

所以把bind-address这行注释掉就完事了。

当然还要记得systemd重启下mysql服务

发表新评论