- 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.