Wondering how to resolve DELETE command denied to user in plesk? Our server management services team is here to lend a hand with your queries and issues.

DELETE command denied to user in plesk

The Delete command in SQL is a part of the Data Manipulation Language, a sub-language of SQL that allows modification of data in databases.

This command is used to delete existing records from a table. Using this, you can either delete specific records based on a condition or all the records from a table.

Usually, WordPress update gets stuck when updating via WordPress Toolkit.

Typical error looks as shown below:

code>In /var/log/plesk/panel.log, the following error is found:

‘/usr/local/psa/admin/bin/filemng’ ‘example’ ‘exec’ ‘/var/www/vhosts/example.com/httpdocs’ ‘timeout’ ‘1800’ ‘/opt/plesk/php/7.4/bin/php’ ‘-d’ ‘safe_mode=off’ ‘-d’ ‘display_errors=on’ ‘-d’ ‘opcache.enable_cli=off’ ‘-d’ ‘open_basedir=’ ‘-d’ ‘error_reporting=341’ ‘-d’ ‘max_execution_time=1800’ ‘-c’ ‘/var/www/vhosts/system/example.com/etc/php.ini’ ‘/usr/local/psa/admin/plib/modules/wp-toolkit/vendor/wp-cli/wpt-wp-cli.php’ ‘–path=/var/www/vhosts/example.com/httpdocs’ ‘–no-color’ ‘core’ ‘update’ ‘–version=5.7.5’ ‘–minor’] with exit code [11]

The following messages appear in /var/www/vhosts/system/example.com/logs/error_log, cumulatively growing:

[fcgid:warn] [pid 21127] [client 203.0.113.2:54350] mod_fcgid: stderr: WordPress-Datenbank-Fehler DELETE command denied to user ‘john_doe’@’localhost’ for table …

Usually, error occurs when DELETE permissions is missing for the database user john_doe.

Today, let us see the steps followed by our Support techs to resolve DELETE command denied to user:

1. Firstly, log in to Plesk.

2. Go to to Domains > example.com > Databases > User Management > john_doe.

3. Check the Delete checkbox in Data Access section and apply the changes.

4. Finally, Update the WordPress instance.