#1045 - Access denied for user

[navien]

Dear Folks,

I'm Navien. New be. I'm using plesk 8.6.0. I have a problem in MySQL when i'm trying to create stored procedure in PHPMyAdmin it shows the error like #1045 - Access denied for user. I tried may things but i couldn't solve this problem. So Please Help me solve this issue.i need a very urgent help.

Thanks in Advance,

Navien

 

[prince]

Hi,

By default, when you create a new database user for your mysql 5 database, Plesk does not enable the necessary privileges for stored procedures and views. You have to add these privileges manually by connecting to mysql as admin.
You can contact you webhosting support team to have it done.