access denied user cpses

behinam

• October 20, 2021 08:48

Hello when I click on views in phpmyadmin, I see this error: Access denied for user 'cpses_az437otgg0'@'localhost' pls help me

• 

  cPanelAnthony

  • October 20, 2021 13:59

  Hello! Could you please review the troubleshooting steps in the following articles and let me know if you're able to resolve the issue? Also, do you get the same issue if you access PHPMyAdmin via root or the actual cPanel user rather than a "cpses" user?

  0
• 

  behinam

  • October 20, 2021 15:05

  I login with root and cPanel user, when you're logged into cPanel you get a cpsession assigned, something like cpsess{random_numbers}, when you click on the phpmyadmin icon, you'll call the cPanel authentication services which generates a new cpsession for the user, meaning the session for phpmyadmin and for cPanel are completely different. I change password but problem not solved.

  0
• 

  behinam

  • October 20, 2021 17:33

  I update database username in .frm file related views structure in mysql files and problem solved.

  0
• 

  cPanelAnthony

  • October 21, 2021 19:01

  I apologize for the confusion I had earlier! This all makes a lot of sense; thank you so much for the update and confirmation regarding the fix.

  0

Please sign in to leave a comment.