My database suddenly stopped granting user permissions. This error repeats exactly every 6 hours. Hope for help. Thanks

NguyenXuanDuc

Member
May 17, 2021
5
1
1
Ha Noi Viet Nam
cPanel Access Level
Website Owner
Hello. A week ago, my site was getting "cannot select database" error. After accessing C-panel / MySQL® Databases, I discovered that my database stopped granting user permissions. After I did the reset everything was back to normal. However, exactly 6 hours later this error happened again, I contacted the server to check for the error and they feedback that no log was received. I also changed the database name, username/password but still no improvement. Currently the only solution is that every 6 hours I have to go to C-panel / MySQL® Databases to reset user permissions. Ask the experts to help. Thanks very much.
 

Attachments

Last edited:

andrew.n

Well-Known Member
Jun 9, 2020
611
175
43
EU
cPanel Access Level
Root Administrator
Do you have root access? is there any scripts maybe in crontab which could change/reset the password every 6 hours?
 

andrew.n

Well-Known Member
Jun 9, 2020
611
175
43
EU
cPanel Access Level
Root Administrator
We think if you don't have root access then you should ask your hosting provider to investigate it for you as you don't have access to the files you might need to check to figure out the reason :)
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
6,923
917
313
cPanel Access Level
Root Administrator
It is very unlikely there was a cPanel that would cause this type of behavior. It definitely sounds like a problem on the server or a plugin, especially if this is happening at certain intervals.

If you contact your host they will be able to check the system and the logs and get you more details on why this may be happening.
 
  • Like
Reactions: NguyenXuanDuc

andrew.n

Well-Known Member
Jun 9, 2020
611
175
43
EU
cPanel Access Level
Root Administrator
Make sure you check crontab under cPanel account to ensure none of your cronjob are causing this.
 
  • Like
Reactions: cPRex