Thanks Brian, > However the error message suggests something beyond that is going on.
Yeah, that would not surprise me. The initial MySQL database and mwuser was setup around 2005 or so. It probably missed a lot of improvements over the years. I don't want to mess with it any more than necessary because I'm not a MySQL admin. I don't know how to fix it. Jeff On Fri, Mar 31, 2023 at 2:47 AM Brian Wolff <[email protected]> wrote: > > 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. > > > 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. >> _______________________________________________ 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/
