WeBWorK Main Forum

Problem with wwmysqldump

Problem with wwmysqldump

by Eric Stroyan -
Number of replies: 2

When I try to run wwmysqldump (either using sudo or su) I get the following error:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump table spaces

Any help would be appreciated

In reply to Eric Stroyan

Re: Problem with wwmysqldump

by Danny Glin -

You shouldn't need sudo to run mysqldump.  It just depends on the mysql credentials.

According to a quick google search, there are two ways to solve this:

  1. Run mysqldump with the --no-tablespaces option
  2. Grant the PROCESS privilege to the user who is running mysqldump: as the mysql root user:
    GRANT PROCESS on *.* to webworkWrite@localhost;
    (assuming webworkWrite@localhost is the user)