- Plesk 12.0 for Linux
- Plesk 12.5 for Linux
- Plesk Onyx for Linux
Backup task in Plesk fails with the following error:
CONFIG_TEXT: Warning : mysql "mydatabase"
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.
In order to resolve the issue, it is required to create the user or to remove it from the database dump.
Log into the server via SSH
Log into Plesk database with the following command:
# plesk db
Create the user with the same name and give him privileges to manage corresponding database:
MYSQL_LIN: mysql> CREATE USER 'database_user'@'localhost' IDENTIFIED BY 'plain_password';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON mydatabase.* To 'database_user'@'localhost' IDENTIFIED BY 'plain_password';
Also, it is possible to create another user in Plesk for managing the database:
Go to the Domains > example.com > Databases > User Management and click Add Database User.
Fill the required information and select the
Enable checkbox Use this user's credentials by default for accessing phpMyAdmin.
In case the issue persists, run
plesk repair mysql utility to perform the check:
# plesk repair mysql
Note: Check Plesk Administrator's Guide for details regarding
plesk repair utility.