Article ID: 123074, created on Oct 6, 2014, last review on Aug 4, 2015

  • Applies to:
  • Plesk 12.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows


Backup task in Plesk fails with an error:

Warning:         mysql "database_name"
mysqldump: Got error: 1449: The user specified as a definer ('database_user'@'localhost') does not exist when using LOCK TABLES


User set as a definer is missing on the system.


Create a user with the same name and give him privileges to manage corresponding database.

CREATE USER 'database_user'@'localhost' IDENTIFIED BY 'plain_password';
GRANT ALL PRIVILEGES ON database_name.* To 'database_user'@'hostname' IDENTIFIED BY 'plain_password';

Search Words

Cannot dump database content of type 'mysql'

backup manager is gone

01bc4c8cf5b7f01f815a7ada004154a2 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f ed7be2b984f9c27de1d2dc349dc19c6d 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF