Question Remote MySQL

[caygri]

Hello,

how can I activate remote access for mysql database?
I follow this q&a How to enable remote access to MySQL database server

In Tool&setting > database is select access to remove for everyhost

Why not work?

 

[AYamshanov]

Hi caygri,

What issue do you want to resolve?
- Do you want to allow Plesk connect to remote Database? The solution is described in Q&A.
- Do you want to allow to every host to connect to Plesk database? (This is about settings in Tools & Settings)

Check that MySQL binds to a network interface. Check also a firewall, may be the firewall blocks packet from/to a remote system.

 

[Martin Mocik]

Hi

I have problem today with remote connection to mysql / mariadb . I have commented bind-address in my.cnf and now its working. I hope this will help you

 

[toomanylogins]

I also had this problem local user was set to allow remote connection but could not.

 

[qtwrk]

not only allowed mysql server to be connected remotely , make sure you also granted the user to be able to connected remotely

 

[toomanylogins]

My user had correct rights the domain was restored from a backup 12.5 -> 17.5. I had to comment the bind to get this to work. There is a bug somewhere.