Enable Remote Access In Plesk 9.5.1

[blackmetal]

Hello,
i want connect to my plesk database via mysql remote administrator but i can not and when i check mysql port with nmap it says 3306 is closed it seems plesk working with socket piping in my serevr i want know how can i enable remote access in my plesk server for my databases?

Thank You,

 

[atomicturtle]

Check your firewall rules, I'll bet you're blocking 3306

 

[blackmetal]

i check 3306 in my csf and also i add it my csf whitelist then restart firewall but nmap says mysql port is closed yet,

 

[atomicturtle]

Try it from localhost, assuming you havent set skip-networking in /etc/my.cnf

 

[breun]

Check the Host field for the user you're trying to login as. If it's set to 'localhost' MySQL will only allow logins using those credentials from localhost. You can add additional entries for specific IP addresses or set the Host field to '%' which allows connecting from any address. I believe by default Plesk uses '%' for new users created through Plesk.