Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps - Status | Demo | Docs | Install
  1. Cloudron Forum
  2. WordPress (Developer)
  3. MYSQL Updraft question

MYSQL Updraft question

Scheduled Pinned Locked Moved WordPress (Developer)
1 Posts 1 Posters 6 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    miednr
    wrote last edited by
    #1

    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?

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Don't have an account? Register

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • Bookmarks
    • Search