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

[NguyenXuanDuc]

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.

 

[andrew.n]

Do you have root access? is there any scripts maybe in crontab which could change/reset the password every 6 hours?

 

[NguyenXuanDuc]

Do you have root access? is there any scripts maybe in crontab which could change/reset the password every 6 hours?

Hello Andrew. How do I know I have root access. Thanks

 

[cPRex]

@NguyenXuanDuc - root access would mean that you have access to not only your cPanel account, but also to the WHM panel for the entire server. If you don't have that level of access, it would be best to speak to your hosting provider about this problem so they can check things on their end.

 

[NguyenXuanDuc]

@cPRex Do you think if I don't have root access someone changed the code in Cpanel that makes this happen? Or is this caused by plugins? Thanks

 

[andrew.n]

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

 

[NguyenXuanDuc]

Thanks

 

[cPRex]

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.

 

[NguyenXuanDuc]

cPRex I contacted the server and they said no error was found. I'm suspecting a plugin is causing this situation

 

[andrew.n]

Make sure you check crontab under cPanel account to ensure none of your cronjob are causing this.