Mysql Views automaticaly deleted

cutepraba

• December 31, 2020 07:43

For the past 4 days all the "views" got deleted automatically in every database. I have contacted the hosting tech support (bluehost) and they checked for malware initially, but now they have no idea why this is happening! any thoughts?

• 

  cPRex Jurassic Moderator

  • December 31, 2020 17:59

  Hey there! I'm sorry to hear about this issue. I wouldn't suspect malware would make this type of change, but it could be caused by permission issues for the user itself. I would recommend checking the permissions for the user at cPanel >> MySQL Databases >> Current Databases >> select the user you want to modify associated with the database you want to modify, and making sure the user has the "create view" privilege there. Can you check that?

  0
• 

  cutepraba

  • January 01, 2021 02:25

  Hey there! I'm sorry to hear about this issue. I wouldn't suspect malware would make this type of change, but it could be caused by permission issues for the user itself. I would recommend checking the permissions for the user at cPanel >> MySQL Databases >> Current Databases >> select the user you want to modify associated with the database you want to modify, and making sure the user has the "create view" privilege there. Can you check that?

  
  Thank you for your time to reply my thread. I checked the privilege and its fine.

  0
• 

  cPRex Jurassic Moderator

  • January 04, 2021 13:41

  That does seem correct. If you have root access to the system, can you submit a ticket so we can check the machine? If you don't have root access, you'll need to work with the hosting provider to determine what changed on the server as you wouldn't have the level of access necessary to check the logs on the system.

  0

Please sign in to leave a comment.