Remote database connection doesn't work anymore

[Johannes P.]

Hello,

i recently added a ssl certificate to my server, made it the default certificate in plesk and use it to secure connections with plesk. I also changed the hostname to match my RDNS entry.

Since then remote database connections don't work anymore, despite the settings being set to "allow remote connetions from any host". I couldn't find anything about this issue in the mysql-logs located in "/var/log/".
Has anyone experienced something similar before? What could be the cause of the problem?

Thank you
Johannes

P.S.: some additional information:

1) "netstat -lntp" shows the following:



2) bind-address in "/etc/mysql/my.cnf" is "127.0.0.1"

3) Firewall Rule for MySQL as shown in "Tools & Settings" -> "Firewall"

 

[Dave W]

Your config only allows mysqld to listen on localhost. In /etc/msyql/my.cnf change the bind-address=* to listen on all interfaces. Restart msyqld.