Resolved Port 3306 closed since MariaDB 10.2 update

[Laurent Gleizes]

Hi everyone,

Since I've upgrade MariaDB from 10.1 to 10.2, I can no longer access databases remotely.

I've followed this article :  How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2/10.3 on Linux?

Firewall is ok. 3306 is open. Even when I stop firewall, 3306 cannot be reached.

I've noticed the following checkbox do not remain checked after validating.
(in English : Allow local MySQL server to accept external connections)

 

[Laurent Gleizes]

I found the solution.

Using Debian, Plesk documentation say to modify the following file : /etc/mysql/my.cnf.

Instead, for MariaDB, the file to check is : /etc/mysql/mariadb.conf.d/50-server.cnf.

I updated the line :

bind-address = 127.0.0.1

to this one :

bind-address = 0.0.0.0

and finally :

service mariadb restart

Hope it may helps someone.

 

[WebHostingAce]

Please make sure you are using Strong or Very Strong passwords(prefer) for all the DB users on this server as Plesk Fail2ban doesn't covered DB users.

 

[FloLa]

I found the solution.

Using Debian, Plesk documentation say to modify the following file : /etc/mysql/my.cnf.

Instead, for MariaDB, the file to check is : /etc/mysql/mariadb.conf.d/50-server.cnf.

I updated the line :

bind-address = 127.0.0.1

to this one :

bind-address = 0.0.0.0

and finally :

service mariadb restart

Hope it may helps someone.

In had to change the following setting in:

/etc/mysql/my.cnf

[mysqld]
bind-address = 0.0.0.0

Then the connection from outside worked for me.

MariaDB Version 10.11.6