I don't know about the error message, but RELOAD is a global right. I dont think you are allowed to grant it to just a specific database instead of all of mysql.
However the error message suggests something beyond that is going on. -- Brian On Thursday, March 30, 2023, Jeffrey Walton <[email protected]> wrote: > Hi Everyone, > > A quick heads up for others in this situation... We attempted to > migrate to MW 1.38.6 tonight. Our first step is a manual backup. > > We found our manual backup (and backups for the last couple of months) > have been failing (yuk!): > > # /sbin/mw-backup > Repair wiki database ok > mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need > (at least one of) the RELOAD or FLUSH_TABLES privilege(s) for this > operation (1227) > Failed to dump wiki database > > It appears this is a known issue on Ubuntu: > https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/2003866 > > In our case, workarounds like adding RELOAD or FLUSH_TABLES to the > backup user also failed: > > mysql> GRANT FLUSH_TABLES ON my_wiki.* TO 'mwuser'@'%'; > ERROR 3619 (HY000): Illegal privilege level specified for FLUSH_TABLES > mysql> GRANT RELOAD ON my_wiki.* TO 'mwuser'@'%'; > ERROR 1410 (42000): You are not allowed to create a user with GRANT > > We reached our limit of knowledge for MySQL administration. I think we > will have to wait until the Ubuntu 2003866 bug is fixed. > > Jeff > _______________________________________________ > MediaWiki-l mailing list -- [email protected] > To unsubscribe send an email to [email protected] > https://lists.wikimedia.org/postorius/lists/mediawiki-l. > lists.wikimedia.org/ >
_______________________________________________ MediaWiki-l mailing list -- [email protected] To unsubscribe send an email to [email protected] https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
