MYSQL Updraft question
-
While using Updraft Plus for WordPress backups, I get this warning message:
Dumping routines: (tq5av_fn_realmedialibrary_childs, wp_fn_realmedialibrary_childs) - (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.)
I would like to enter one of these commands to the WordPress CLI (MySQL):
GRANT SELECT on . TO 'wp_database_user'@'localhost';
GRANT SHOW_ROUTINE ON . TO 'wp_database_user'@'localhost';
I get these error messages:
ERROR 1045 (28000): Access denied for user 'wp_database_user'@'%' (using password: YES)
ERROR 1227 (42000): Access denied; you need (at least one of) the GRANT OPTION privilege(s) for this operation
I understand, that I don't have the privileges, but I am logged in as root. What could I do? Is there another way to reach my goal?