Hi guys,
I have a problem with my database. I updated the vbulletin form 3.6.2 up to the 3.6.8 PL2.
My vbulletin 3.6.2 was hacked and somebody droped all my database. I recovered database from the backup and updated it to the latest 3.6.8 PL2 version.
I denied DROP permissions for the vbulletin MySQL user, and now I have tons of these tables in my database:
aaggregate_temp_********* (this tables are empty) | type --> MEMORY
taggregate_temp_********* ( there is some data there) | type --> MEMORY
and I started receiveing database errors like this:
Invalid SQL:
DROP TABLE IF EXISTS taggregate_temp_***********;
Error MySQL : DROP command denied to user 'user'@'host' for table 'taggregate_temp_**********'
Error Number : 1142
Script : http://****************/forum/cron.php?&rand=91523
Refferer : http://****************/forum/showthread.php?t=2526
Could you help me with these unknown tables in my database? Which previliges for vbulletin mysql users should I set ( Select Insert Update Delete Create Drop Index Alter Tmp Lock)? Which security settings would you suggest to have for vbulletin in MySQL?
Thanks a lot in advance.
I have a problem with my database. I updated the vbulletin form 3.6.2 up to the 3.6.8 PL2.
My vbulletin 3.6.2 was hacked and somebody droped all my database. I recovered database from the backup and updated it to the latest 3.6.8 PL2 version.
I denied DROP permissions for the vbulletin MySQL user, and now I have tons of these tables in my database:
aaggregate_temp_********* (this tables are empty) | type --> MEMORY
taggregate_temp_********* ( there is some data there) | type --> MEMORY
and I started receiveing database errors like this:
Invalid SQL:
DROP TABLE IF EXISTS taggregate_temp_***********;
Error MySQL : DROP command denied to user 'user'@'host' for table 'taggregate_temp_**********'
Error Number : 1142
Script : http://****************/forum/cron.php?&rand=91523
Refferer : http://****************/forum/showthread.php?t=2526
Could you help me with these unknown tables in my database? Which previliges for vbulletin mysql users should I set ( Select Insert Update Delete Create Drop Index Alter Tmp Lock)? Which security settings would you suggest to have for vbulletin in MySQL?
Thanks a lot in advance.
Comment