Unable to install WordPress: DROP command denied to user

Created:

2016-12-22 14:28:21 UTC

Modified:

2017-08-15 08:28:32 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to install WordPress: DROP command denied to user

Issue Symptoms

Installation of WordPress fails with the following error in Plesk:

Error: The following error has occurred during the installation of application:

Installation of WordPress at http://example.com/ failed. Non-zero exit status returned by script. Output stream: 'Unable to execute SQL statement (

DROP TABLE IF EXISTS `wp_commentmeta`): DROP command denied to user 'wordpress_e'@'localhost' for table 'wp_commentmeta'

at (SiteApplicationManager::fsaExecuteScript line 452)
at execute console command --run-application-script(vconsoleapp::start line 122)
at execute "C:\Program Files (x86)\Plesk\admin\bin\sappmng.exe" --run-application-script "--script-filename=configure" "--fsa-xml-file=C:/Program Files (x86)/Plesk/PrivateTemp/fsa5.tmp" "--script-name=install" "--user-name=example" "--application-full-name=file:///C:\Program Files (x86)\Plesk\var\apspackages\aps48D0.tmp.zipc172aff5-e29c-9152-bd\cache"(vconsoleapp::run line 139) (Error code 1)'. Error stream: 'Unable to execute SQL statement (

DROP TABLE IF EXISTS `wp_commentmeta`): DROP command denied to user 'wordpress_e'@'localhost' for table 'wp_commentmeta'

at (SiteApplicationManager::fsaExecuteScript line 452)
at execute console command --run-application-script(vconsoleapp::start line 122)
at execute "C:\Program Files (x86)\Plesk\admin\bin\sappmng.exe" --run-application-script "--script-filename=configure" "--fsa-xml-file=C:/Program Files (x86)/Plesk/PrivateTemp/fsa5.tmp" "--script-name=install" "--user-name=example" "--application-full-name=file:///C:\Program Files (x86)\Plesk\var\apspackages\aps48D0.tmp.zipc172aff5-e29c-9152-bd\cache"(vconsoleapp::run line 139) (Error code 1)'.

Conditions

Customized "%plesk_dir%"\admin\conf\panel.ini

Resolution

  1. Open and edit "%plesk_dir%"\admin\conf\panel.ini by commenting custom records:

    ;[databaseManagement]
    ;features.roles.mysql.readWrite = Select,Update,Insert
    ;features.roles.mysql.readOnly = Select
    ;features.roles.mysql.writeOnly = Update
  2. Save changes.

Have more questions? Submit a request
Please sign in to leave a comment.