Mysql Views automaticaly deleted

cPanel & WHM Version
86.0 (build 34)

cutepraba

Registered
Dec 31, 2020
2
0
1
chennai
cPanel Access Level
Website Owner
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
Staff member
Oct 19, 2014
16,558
2,610
363
cPanel Access Level
Root Administrator
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?
 
  • Like
Reactions: cutepraba

cutepraba

Registered
Dec 31, 2020
2
0
1
chennai
cPanel Access Level
Website Owner
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.
1609471474216.png
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
16,558
2,610
363
cPanel Access Level
Root Administrator
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.