Routines are not backed up

[web.team-1338Participant]

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!

[web.team-1338Participant]

This reply has been marked as moderator-only.

[Bryle CroduaModerator]

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 2 months, 1 week ago by Bryle Crodua.

[Author]

Posts