Hi, for the past 10 days or so, the cronjob that backs up our MySQL db and archives it has failed at the dbbackup
/mysqldump
step, with this error (redacted):
CommandConnectorError: Error running: mysqldump username$db --quick --host=username.mysql.pythonanywhere-services.com --user=username --password=pwd
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
If I try to grant privileges to the user username
with something like:
GRANT ALL PRIVILEGES ON username$db . * TO 'username'@'username.mysql.pythonanywhere-services.com';
I get
ERROR 1045 (28000): Access denied for user 'username'@'%' (using password: YES)
Some information on the web suggests that this issue is due to a recent MySQL update. Regardless, why doesn't the user that's supposedly the owner of the db have these privileges, and why can't I grant those privileges (at least PROCESS) when I'm logged in as that user? Does anyone know the correct command for this? Thanks.