• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

#1045 - Access denied for user

N

navien

Guest
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
 
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.
 
You must log in or register to reply here.

Similar threads

M
Resolved Unable to export database. Error message: -- Connecting to localhost... mariadb-dump: Got error: 1045: "Access denied for user '<userx>'@'localhost'
Replies
1
Views
327
maredzki
M
S
Issue DB query failed: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: NO)
Replies
1
Views
1K
Kaspar@Plesk
Kaspar@Plesk
Edi Duluman
Resolved Access denied for user 'admin'@'localhost' after dist-upgrade
Replies
2
Views
771
Edi Duluman
Edi Duluman
B
Issue Plesk Migration Tool: Access denied for user 'admin'@'localhost' (using password: YES)")
Replies
1
Views
893
Peter Debik
P
Y
Resolved SQLSTATE[HY000] [1045] Access denied for user 'es_fprkmvi'@'localhost' (using password: YES)
2
Replies
23
Views
19K
laurentakn
laurentakn
Back
Top