0
I have a Wordpress module (Cerber) that for some obscure reason, is deleting a table (cerber_files). The developer does not manifest.
I wonder if there are any commands that prevent a mysql table from being deleted (drop)?
1 answer
0
You can use the REVOKE command to do this. An example:
REVOKE DROP ON minha_tabela FROM nome_do_usuario;
The username would be the user used by Wordpress to connect in the database.
Here is more information:
https://www.techonthenet.com/mysql/grant_revoke.php
http://www.mysqltutorial.org/mysql-revoke.aspx
https://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html#priv_drop
Browser other questions tagged mysql
You are not signed in. Login or sign up in order to post.
Thank you for the answer. I tried to do
REVOKE DROP ON cerber_files FROM rogeriod_sestra;via Phpmyadmin but apparently the commandREVOKEis not being recognized:Error
Static analysis:

1 errors were found during analysis.

Unrecognized statement type. (near "REVOKE" at position 0)
SQL query:

REVOKE DROP ON cerber_files FROM rogeriod_sestra

MySQL said: Documentation

#1142 - GRANT command denied to user 'rogeriod'@'localhost' for table 'cerber_files'– Rogério Dec