WordPress absolutely does need “DELETE“, otherwise it has no way to delete posts or tags or options rows or anything else.
The “DROP” command is sometimes used during upgrades, although it’s been a long time. The last time I think it was used was during the WordPress 2.3 update, which removed the assorted categories tables in favor of the new taxonomy tables. I would not say it is safe to remove it, but I doubt it would cause you any real problems for now. A solid backup plan in place is a better idea than removing it. Frankly, if something gets to the point where they can run raw SQL commands on your system, you’re already in trouble, denying DROP won’t help much.
Plugins will occasionally create their own tables and do things like this. DROP is pretty rare though, except during a plugin uninstall process.
Related Posts:
- Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
- Cannot add or update a child row: a foreign key constraint fails
- How to make MySQL table primary key auto increment with some prefix
- sql query with multiple where statements
- Cannot delete or update a parent row: a foreign key constraint fails
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- Syntax error due to using a reserved word as a table or column name in MySQL
- MySQL root password change
- Installation of MySQL for Visual Studio 1.2.8 failed
- How do I import an SQL file using the command line in MySQL?
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- Select from multiple tables without a join?
- SQL Query Where Field DOES NOT Contain $x
- Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
- MySQL Error 1093 – Can’t specify target table for update in FROM clause
- mysqladmin: connect to server at ‘localhost’ failed
- mysql update multiple columns with same now()
- Mysql command not found in OS X 10.7
- MySQL – UPDATE query based on SELECT Query
- grabbing first row in a mysql query only
- mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
- Order a MySQL table by two columns
- MySQL AS keyword
- Should I use the datetime or timestamp data type in MySQL?
- Access denied; you need (at least one of) the SUPER privilege(s) for this operation
- How do I change the data type for a column in MySQL?
- Unknown Column In Where Clause
- Getting java.sql.SQLException: Operation not allowed after ResultSet closed
- Cannot connect to Database server (mysql workbench)
- mysqld: Can’t change dir to data. Server doesn’t start
- How to solve “Error: MySQL shutdown unexpectedly”?
- Can you do a For Each Row loop using MySQL?
- Drop all databases in MySQL
- CAST to DECIMAL in MySQL
- How to properly create composite primary keys – MYSQL
- MySQL – count total number of rows in php
- How to get the count of each distinct value in a column?
- Data is not constantly loading from custom wordpress table
- How do you properly prepare a %LIKE% SQL statement?
- How to run WordPress across 2 VMs for high availability
- Mysqldump add drop table?
- How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
- “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
- #1115 – Unknown character set: ‘utf8mb4’
- WordPress Deadlock Error
- How to do a MySQL dump from production site without using a search and replace script for local development?
- How to bulk edit canonical url’s in SQL?
- Concurrent / simultaneous MySQL connections
- How to check for empty and not a failure
- Database: Custom table: sprintf value for DateTime column
- How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
- Keeping database within limits, please help!
- Best settings for MySQL to speed up site? [closed]
- WP_USE_EXT_MYSQL
- HTML Entities in Post Title
- Can’t find my wordpress DB in phpmyadmin
- Deprecated: mysql_connect():
- WordPress post_status is future, manually added
- How are multiple WordPress WPDB queries handled?
- $wpdb select all meta for each post
- Calculate average crossing post categories
- Replacing link URL ending strings via MySQL
- Many slow queries post_type = ‘attachment’;
- SQL command to convert all tags in lowercase?
- Problem with admin login after deployment
- Find out how many times the user has logged in
- WordPress plugins for database queries
- Is it possible to create a WordPress table using array and loop?
- Can’t run database query
- WordPress doesn’t display accents after migration
- How to stop $wpdb from prepending database name
- Match tag names with form titles
- Error missing MySQL extension
- Getting Error Trying to Create Table
- Best approach for a custom database filling in WP custom post types
- Why doesn’t custom mysql query return results? Is syntax correct?
- $wpdb->get_var multiple queries in one database check
- List users with the most posts in the last 30 days
- Way to extract wordpress data from folder backup
- Data is not constatntly loading from custom wordpress table
- Mysql Server keeps crashing
- edit_user_created_user hook – using to update Groups
- How to search usermeta table
- How to add virtual column in wpdb get_result statement
- PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
- I want to share local developement and staging DB — Is this very smart or very stupid?
- Extract all users along with yoast metadata description
- WordPress asks to install, but is already installed?
- Deleting a table row through query
- An SQL query to find orphaned image attachments and their meta
- Weird characters displayed when importing WordPress MySQL db
- Simple SQL Query in wordpress
- optimise SQL wordpress call
- WP_Query with LIKE returns strange query
- Where other than wp-config can database access details be defined?
- remove wordpress post links
- SQL get last entry of a specific gravity form
- Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
- How can I show user’s privileges in MySQL?
- Changing host permissions for MySQL users