MYSQL Updraft question

[miednr]

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?

[joseph]

@miednr WP (or any app on Cloudron) does not have root access to the database. The root user (in the terminal) is totally different from the database user. It is also not possible to elevate the existing database user to have extra permissions. Unfortunately, this means that Updraft Plus cannot take a backup of the stored procedures (if any). Cloudron's backup database dumps should have them though.

[miednr]

@joseph

Thank you for this clear information.