Having trouble with database permission-related issues with Duplicator Pro? This guide provides practical solutions to troubleshoot and resolve the various database permission-related issues effectively.

To begin with, make sure you are using the latest version of Duplicator Pro. Please check the changelog and system requirements.

Common Error Messages

If using Duplicator during any phase you receive a message about database access issue then consider these solutions:

Error: SELECT command denied to user ‘some-user’@’localhost’ for table ‘user’

If you encounter database connection issues during the installation process, please refer to the FAQ below and navigate to the section titled “Access Denied” for troubleshooting steps:
How to resolve various Database Issues?

Command Denied Messages

If you encounter “command denied” messages, consider the options below.

Minimum Required Privileges: Rather than granting ALL PRIVILEGES, Duplicator only needs the following to complete an install: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, INDEX, and LOCK TABLES. If your host or security policy prefers granting the minimum set, provide this list to your hosting provider or DBA.

If you’d rather keep it simple, in cPanel, check the “All PRIVILEGES” checkbox for the database user that is having access issues. Here are some examples:

• How to Grant all Privileges to a User in MySQL with cPanel
• How To Create or Delete a MySQL Database or User

Note: If you’re not technically inclined, the quickest solution is to reach out to your hosting provider or server administrator. Simply provide them with the error message, and they can enable the necessary permissions for you.

For various command line options, see GRANT General Overview

If you’re seeing database issues during backup creation rather than installation, see Resolving Database-Related Build Issues. For write errors during installation specifically, see How to Fix Database Write Issues.