Cant provide any privilege to users/databases

hmaddy

Well-Known Member
May 6, 2020
267
29
28
Chennai
cPanel Access Level
Root Administrator
cant provide any privilege to any user or database from cpanel. i think the user privilege table is missing. so how can i fix this issue.

No Error message., just i cant save the privilege.


tailf /var/lib/mysql/linr1.myser.com.err
2022-01-13 11:57:30 140041708279552 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:57:59 140041707972352 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:58:29 140042188314368 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:58:31 140041707972352 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:58:33 140042188314368 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:58:37 140041707972352 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:58:59 140042175616768 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 11:59:50 140042175002368 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 12:02:52 140041707972352 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
2022-01-13 12:02:56 140042175309568 [Warning] Access denied for user 'mykart_mykart'@'localhost' (using password: YES)
 

Attachments

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
712
278
363
cPanel Access Level
DataCenter Provider
And you're 100% sure you have the password correct? Have you tried resetting it to what you want to it be? We've seen clients get a space (for example) on the end of the password when they set it up.
 

hmaddy

Well-Known Member
May 6, 2020
267
29
28
Chennai
cPanel Access Level
Root Administrator
yes, its correct. some others told that the user tables are missed. where these privileges and mysql details are saved
 

kodeslogic

Well-Known Member
PartnerNOC
Apr 26, 2020
428
202
118
IN
cPanel Access Level
Root Administrator
Try deleting the database user and recreating it then map it to the database again.
 
  • Like
Reactions: cPanelAnthony