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

NguyenXuanDuc

• May 17, 2021 01:30

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

  • May 17, 2021 13:38

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

  0
• 

  NguyenXuanDuc

  • May 17, 2021 14:14

  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

  0
• 

  cPRex Jurassic Moderator

  • May 17, 2021 15:05

  @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.

  0
• 

  NguyenXuanDuc

  • May 17, 2021 22:24

  @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

  0
• 

  andrew.n

  • May 18, 2021 13:25

  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 :)

  0
• 

  NguyenXuanDuc

  • May 18, 2021 13:35

  Thanks

  0
• 

  cPRex Jurassic Moderator

  • May 18, 2021 14:17

  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.

  0
• 

  NguyenXuanDuc

  • May 18, 2021 14:28

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

  0
• 

  andrew.n

  • May 18, 2021 15:56

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

  0

Please sign in to leave a comment.