Unable to connect to Mysql hosts !

[regisg]

Hello,

After changing my web hosting (same system : VPS, same version of linux : CentOS 6 , but passage from Plesk 11 to 12), i am now unable to connect remotely via TCP-IP to my mysql databases (with third-party tools like Mysql Workbench, Toad...) ! I never met this problem before.

The only way to connect is to use a "Standard TCP-IP over SSH" connection method ... but i don't want (i did'nt need this method before) !

Though, remote connections are allowed from any host in the settings.

Please could you help me ?

Thanks a lot.

 

[ScottGoddard]

Hi

You probably already know but it is worth clarifying that Plesk has 2 places to control if remote MySQL connections are allowed.

Server wide at: Home>Tools & Settings>Database Hosting Preferences

By User at: Subscription>Websites & Domains>Databases>Database User

If they are both correct it would probably be best to check the privileges for the user directly with MySQL (Using PHPMyAdmin is probably easiest but command line if you are comfortable with it) and to ensure the firewall (or something else) is not blocking the remote port (usually 3306 but best to check using PHPMyAdmin or command line).

Scott

 

[regisg]

Hello,

Thanks for your message.

Indeed, i checked everywhere "Allow remote connections from any host", and also "Make the user default for this database" for each DB user.

With regards to the privileges, it looks correct for the users, for example :
user : dbown_user
client : %
type : specific to this dB
privileges : ALL PRIVILEGES

Thanks again,
Régis

PS : i have two IP adresses on my server, maybe it caused an issue...

 

[regisg]

Well, we found that mysql port 3306 was closed... why ?????

So what i don't understand is why my wordpress website works on this server...

Please could someone tell my how can i open this port (with plesk) ?