Can't access MySQL from 3rd party program

[thedust2010]

It seems the only way I can access MySQL is through Plesk's PHPMyAdmin tool. I have purchased MySQL Explorer (from mysqltools.com) and while I've been able to connect to some other web servers I have purchased space on, I cannot access the Plesk web server that I administrate. Instead when I try to connect I get:

[MySql Server DMO Error][ErrNo:1045][Description: Access denied for user: 'cpdataba_iej38d@x.x.x.x' (Using password: YES)]

I am using the IP address for the web site, the proper database name and username and password. Port is set to default (3306). Anyone know why this is happening? Very frustrating!

 

[jamesyeeoc]

Have you already made sure the 'mysql' database, 'user' table has an entry for "cpdataba_iej38d@x.x.x.x" and has HOST set for the IP address? And the proper permissions set?

Basically the same thing to do if you were using phpMyAdmin as well.