I recommend setting a new MySQL user for backups and never using the root MySQL account to do backups.
Step 1. Log on to MySQL as root:
mysql -u root -p
Step 2. Create a new user and grant all necessary permissions:
CREATE USER 'backup_user_name'@'localhost' IDENTIFIED BY 'my_pass';
GRANT SELECT, SHOW VIEW, RELOAD, EVENT, TRIGGER, LOCK TABLES ON *.* TO 'backup_user_name'@'localhost';
![Create a new MySQL user dedicated to backups image 80 - Create a new MySQL user dedicated to backups](https://i0.wp.com/pcx3.com/wp-content/uploads/2022/04/image-80.png?resize=736%2C203&ssl=1)
Now you can use that user for backing up MySQL databases.