How to fix error in mysql backup?

Question

MySQL

Hello! I can’t understand why I don’t have a backup of the base. Help please! Team:

MYSQL_HOST='127.0.0.1';
MYSQL_USERNAME='admin_root';
MYSQL_DB='main_data';
MYSQL_PWD='123456'
MYSQL_PWD=${MYSQL_PWD} mysqldump -h "${MYSQL_HOST}" -u "${MYSQL_USERNAME}" "${MYSQL_DB}" > "/tmp/${FILENAME}

I am getting this error

'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

what's wrong?

Answer 1

GRANT PROCESS ON *.* TO 'admin_root'@'localhost'

Answer 2

A little off topic, but if you dump a working database, then read more about single transactions
https://www.google.com/amp/s/ruhighload.com/%25D0%...

Answer 3

If you do not use TABLESPACE, then you DO NOT need to add new rights!
You need to specify the --no-tablespaces option when calling mysqldump.