https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23329 --- Comment #86 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> ---

From David Cook on koha-devel:

I was looking at https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23329#c85 where Jonathan points out under MySQL 8 that we’re now getting this error with dumping the database: “mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces” I’ve seen this pop a few times myself on Koha projects, and it looks like it traces back to the security notes listed here: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-31.html “Incompatible Change: Access to the INFORMATION_SCHEMA.FILES table now requires the PROCESS privilege.” “This change affects users of the mysqldump command, which accesses tablespace information in the FILES table, and thus now requires the PROCESS privilege as well. Users who do not need to dump tablespace information can work around this requirement by invoking mysqldump with the --no-tablespaces option. (Bug #30350829)” I haven’t looked into it too deeply yet, but I imagine adding the --no-tablespaces option to mysqldump in koha-dump is the way to go. -- You are receiving this mail because: You are watching all bug changes.