| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu 20.04 LTS |
| Webmin version | 2.013 |
| Virtualmin version | 7.5 |
| Related packages | MySQL |
So, a recent minor point update of MySQL has broken mysqldump when you use --single-transaction (which we do all the time).
MySQL did an update to their mysqldump dump package for the better, but unfortunately, the change came in a minor patch release and has broken MySQL dump backups for some users
The issue is that the fix requires editing the permissions for all database users - and as far as I can tell from looking about in VirtualMin… there is no UI for managing permissions of database users? Is that correct?
Further, trying to execute the solution as presented in that article fails, even when logged into MySQL as the root user.
mysql> select `User`,`HOST`, `Process_priv`,`Reload_priv` from mysql.user;
+------------------+-----------+--------------+-------------+
| User | HOST | Process_priv | Reload_priv |
+------------------+-----------+--------------+-------------+
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| redacted | localhost | N | N |
| mysql.infoschema | localhost | N | N |
| mysql.session | localhost | N | N |
| mysql.sys | localhost | N | N |
| root | localhost | Y | Y |
| redacted | localhost | N | N |
+------------------+-----------+--------------+-------------+
14 rows in set (0.00 sec)
EDIT:
With how VirtualMin is set up, the fix requires you to specify ‘localhost’ and not ‘%’. E.g.,
mysql> GRANT RELOAD,PROCESS ON *.* TO 'theuser'@'%';
ERROR 1410 (42000): You are not allowed to create a user with GRANT
vs
mysql> GRANT RELOAD,PROCESS ON *.* TO 'theuser'@'localhost';
Query OK, 0 rows affected (0.03 sec)