Failed to restore server backup: command denied to user backup_o2wVK28

Created:

2016-11-16 13:00:26 UTC

Modified:

2017-08-10 15:09:08 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Failed to restore server backup: command denied to user backup_o2wVK28

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.5 for Windows

Note: This article has the reference to the issue with the fix available:

  • #PPPM-3628 "MySQL database views were not restored from backup, if the value of the “Default settings for remote access of database users” option in Database Hosting Settings was changed to “Allow local connections only”."
    Fixed in:
Please consider updating your server:

Symptoms

  1. During the restoration process, the following error occurs:

    Execution of /usr/bin/mysql --no-defaults -u backup_410QPkk -h localhost -P 3306 --default-character-set utf8 *database name* failed with return code 1. Stdin is source /tmp/migration-unpack-tfiayb/backup_*backup date*; exit Stderr is ERROR 1227 (42000) at line 76 in file: '/tmp/migration-unpack-tfiayb/backup_*backup date*': Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  2. The option

    "Home -> Tools & Settings -> Database Servers -> Database Hosting Settings -> Allow remote connections from any host "

    is turned off.

  3. Also, the following error may appear during restoration process:

    Warning: Restore domain "example.com"
    Failed deployment of database example_db (domain example.com)
    Warning:
    Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: databases\\example_db_1[sqldump]: Hs_full_example_db_1_sqldump_1601110901.zip
    Warning:
    Execution of "C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\/mysql" --no-defaults -u backup_o2wVK28 -h localhost -P 3306 --default-character-set utf8 example_db failed with return code 1. Stdin is source C:\\Program Files (x86)\\Parallels\\Plesk\\PrivateTemp/migration-unpack-01d1542c6031ddb0/tmp22587.tmp exit Stderr is ERROR 1370 (42000) at line 926 in file: 'C:\\Program Files (x86)\\Parallels\\Plesk\\PrivateTemp\\migration-unpack-01d1542c6031ddb0\ mp22587.tmp': alter routine command denied to user 'backup_o2wVK28'@'%' for routine 'example.routine'

Cause

This is a software issue with internal ID #PPPM-3628 . The issue is fixed in Plesk 12.5 MU #22.

Resolution

Install the latest microupdates using Plesk autoinstaller.

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