Unable to Backup Database with Backup WordPress Site by WPvivid

by | Mar 20, 2019 | Problems | 0 comments

Thanks for Albertramsbottom offering a feedback to us.

The issue description

Albertramsbottom said:

I just get the following error

Error: Backup error: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user ‘myuser’@’localhost’ to database ‘mydb’, task id: wpvivid-5c879c9530f36

Cheers

The cause of issue

The MySQL user didn’t have sufficient privileges to database, which caused database backup failure.

The solution

Before creating backups for WordPress site, please make sure that the MySQL user is granted the all privileges to database. There are two different ways to grant privileges to users:

Method 1: log in phpmyadmin>>Users tab>>Edit Privileges of MySQL user>>Database-specific privileges>>Select your database>> Check All >> Click Go button.

Method 2: run the command line below:

msyql –u root –p;
GRANT ALL PRIVILEGES ON database_name.* TO ‘user_name’@’localhost’;
flush privileges;

Note: replace database_name and user_name with your database name and username.

Submit a Comment