- This topic has 2 replies, 2 voices, and was last updated 6 months, 3 weeks ago by Bryle Crodua.
-
Posts
-
Hi! I am receiving this warning on my backups:
“Dumping routines: (SearchInDatabase) – (Failed – Your WordPress database user doesn’t have sufficient privileges to read these stored routines. To be able to backup the routines, you must be the user named as the routine DEFINER(s), have the SHOW_ROUTINE privilege (for MySQL 8.0.20+ users), have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that includes the routines.)”
It seems to me that all my privileges are set:
https://drive.google.com/file/d/11s3ozvsenjPIu3lyML9BvX1cu0wBfsIX/view?usp=sharing
I must admit that I’m a bit confused. Can someone assist me in resolving this issue?
Here is the log: https://pastebin.com/35d00Np4
Thank you in advance!
Hi,
Your WordPress database user would need the SHOW_ROUTINE privilege or a global SELECT privilege.
You would need to run either of these SQL statements from your root database account
GRANT SELECT on *.* TO ‘wp_database_user’@’localhost’;
GRANT SHOW_ROUTINE ON *.* TO ‘wp_database_user’@’localhost’;replace wp_database_user with your WordPress database user. Your host might also be able to do this for you.
Thanks,
Bryle- This reply was modified 6 months, 3 weeks ago by Bryle Crodua.
- The topic ‘Routines are not backed up’ is closed to new replies.