Problem

[BrenoB]

Integration between Plesk Pannel and MySQL External Server

Hi everybody;

I'm running Plesk Pannel 11.5 for Windows in a Server, and I'm trying to add a new MySQL Server (Tools & Setiings -> Database Servers -> Add Database Server) but I've got an error: Access denied for user 'root'@'%' to database 'd52b1de48c958c.

The root user and password that I'm trying are correct, I can connect at the MySQL server using other client or directly on server.

Has anyone faced this problem? What did you habe to do to fix the problem?

Any help will be appreciated.

Thanks.

Breno

 

[BrenoB]

Hi everybody;

I'm running Plesk 11.5 for Windows and I'm trying to add a new My SQL Server (Tools & Settings -> Database Servers -> Add New Database Server). But when I try, I face the follow error: Access denied for user 'proot'@'10.198.112.55' (using password: YES) Account does not have administrativa privileges.

I made some testes on MySQL Server and the account that I'm using has permission (is root account), only when I try by Plesk I face this error.

Has anynone faced this error? What did you do to fix it?

Thanks for your help

Breno

 

[HMoellendorf87]

Hi Breno,

did you checked the mysql database, table users? Are you sure, that you allowed root from the IP of the Plesk Panel server? There are different rules. You can grant root access from specific IPs only or only localhost.
Please doublecheck that first.

 

[HMoellendorf87]

Forum Administration:

Please merge this thread with the "Problem" thread, as it is the same problem.
Thanks a lot.

 

[IgorG]

'proot'@ ?
Why not 'root'@ ?

 

[BrenoB]

Hi IgorG; Yes, the correct is 'root'. I think I typed 'p' unconsciously.

Hi Henning; the connection for user root was allowed, but it wasn't the problem.

We've fixed the problem, it was privileges. Using the command on MySQL Server "GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '#wCdCm2' WITH GRANT OPTION" it worked.

Thanks for your replies.