• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

Issue Remote connection to Mysql fails

xdefays

New Pleskian
Hi,
I am new with Plesk. I already checked most of the documentations, but i am having an issue setting up a Mysql DB allowing remote access.
Here are the things i already checked :
1/ Tools & Settings > Database Servers > ALLOW REMOTE CONNECTIONS FROM ANY HOST
2/ Databases > Database Users > ALLOW REMOTE CONNECTIONS FROM ANY HOST
3/ Tools & Settings > Firewall > I added the following rule : Allow incoming from all on port 3306/tcp

To test connection, i tried using SEQUEL PRO. I get this error : Can't connect to MySQL server on 'XX.XX.XX.XX' (61)
I also tried to run a website hosted on another server but using a Plesk DB, but it also fails.

Does any of you know what should i do ? (remember i am new at this, be gentle :D )

Thanks,

Xavier
 
Hey !
After more researches, i finally got it to work !
For those interested, here is how :
I edited mysql/my.cnf and changed the bind address to 0.0.0.0 (+ restart sql server)
Xavier
 
Back
Top