- 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.
At first, try to sync mysql users with Plesk repair utility. For that:
- Log into the server via SSH.
plesk repair mysqlutility to perform the check:
# plesk repair mysql
In case the issue will persist, proceed further with the manual fix:
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 affected database.
Enable checkbox Use this user's credentials by default for accessing phpMyAdmin.