DB-User: Missing Privileges

Hi @nm4609 ,

Thanks for contact Duplicator support!

Could you please let me know what you are trying to achieve?
And please share the error message you got.

About your question: “

What are the exact requirements for the new version”
I’m consulting the plugin developer about your question, and I will reply here once I get feedback.

Thanks!

Hi?@nm4609?,

Please refer to the below FAQ for information about Duplicator requirements:

• System Requirements
• https://snapcreek.com/duplicator/docs/guide/#guide-manage-005-q

Thanks!

Thx for feedback.

Systemrequirement is fulfilled.

The problem appaers during the installation.

Warning:

“The user [db-user-name] is missing privileges on the database [db-name] You can continue with the installation but some features may not be restored correctly.”

And concerning of the installed plugins the WordPressinstallation will work or not ?? :/

These privileges can bet set/ are set with CPanel:

ALTER, CREATE, CREATE TEMPORARY TABLES, DELETE, INDEX, LOCK TABLES, SELECT, TRIGGER, ALTER ROUTINE, CREATE ROUTINE, CREATE VIEW, DROP, EXECUTE, INSERT, REFERENCES, SHOW VIEW, UPDATE

In one case I got the following error message in the log file:

START TEST “Privileges: User Resources” [CLASS: DUPX_Validation_test_db_user_resources]
DB QUERY [ERROR][/…/dup-installer/classes/database/class.db.php:645] MSG: SELECT command denied to user ‘db-user-name’@’localhost’ for table ‘user’
SQL: SELECT max_questions, max_updates, max_connections FROM mysql.user WHERE user = ‘db-user-name’ AND host = ‘localhost’
TRACE[1] CLASS___: DUPX_DB::mysqli_query FILE: /…/dup-installer/classes/validation/class.validation.database.service.php[742]
TRACE[2] CLASS___: DUPX_Validation_database_service->getUserResources FILE: /…/dup-installer/classes/validation/database-tests/class.validation.test.db.user.resources.php[28]
TRACE[3] CLASS___: DUPX_Validation_test_db_user_resources->runTest FILE: /…/dup-installer/classes/validation/class.validation.abstract.item.php[46]
TRACE[4] CLASS___: DUPX_Validation_abstract_item->test FILE: /…/dup-installer/classes/validation/class.validation.manager.php[232]
TRACE[5] CLASS___: DUPX_Validation_manager->runTests FILE: /…/dup-installer/classes/validation/class.validation.manager.php[205]
TRACE[6] CLASS___: DUPX_Validation_manager->getValidateData FILE: /…/dup-installer/ctrls/classes/class.ctrl.ajax.php[173]
TRACE[7] CLASS___: DUPX_Ctrl_ajax::actions FILE: /…/dup-installer/ctrls/classes/class.ctrl.ajax.php[95]
TRACE[8] CLASS___: DUPX_Ctrl_ajax::controller FILE: /…/dup-installer/main.installer.php[56]

———

B.R.

Hi?@nm4609?,

Please try the below to fix your issue:

This is a weird issue as you’ve mentioned that you’ve granted all the privileges to the database user over the database.

Could you please try to delete the database and create another one?

You also could try the below:
In the first step of the installer, enable the option: Remove security DEFINER declarations in the Options section, under the Database tab as the below screen shows:
https://a.supportally.com/i/lSwa8C

I hope this helps.

Thanks!

Hi @nm4609 ,

I’m closing this ticket for inactivity. Please don’t hesitate to contact us in a new ticket if you need any help with Duplicator.

Thanks!