Thread Starter
Marty
(@bozzmedia)
mysqldump is enabled and the plugin recognizes it.
I tried to paste some more info about my setup from the logs but the new forum post editor doesn’t allow me to unfortunately.
Apache, innodb, php 8, redis object cache, nginx page cache
Hi, You need to check with your hosting provider to make sure the db user has these permissions. This error tells you what permissions are needed:
mysqldump: Couldn’t execute ‘FLUSH TABLES’: Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)
Thread Starter
Marty
(@bozzmedia)
Interesting. The current user has all privileges. I will try with a new user.
Thread Starter
Marty
(@bozzmedia)
<!– wp:paragraph –>
<p>I just tried with a brand new user, all privileges, same error.</p>
<!– /wp:paragraph –>
Please try to contact your hosting provider and let them know about this error. They will point you in the right direction.
Here you can find more information about this error: https://stackoverflow.com/questions/9972651/flush-tables-access-denied
Thread Starter
Marty
(@bozzmedia)
Thank you, they were able to resolve it.
In case it’s helpful, here’s what my host had to say about why it changed recently. I’m not sure if this was a whm/cpanel update or what.
I can see that the MySQL conf file was updated roughly 20 hours ago, though not sure what changes were made, the MySQL mode is now set to STRICT_TRANS_TABLES:
sql_mode=”STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION”
