Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied

Document ID : KB000007272
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

mysql dump command fails with can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied

Resolution:

1. Run the following command to backup mysql DB if you come across this error "can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied"

 mysqldump --skip-lock-tables -u root -p --all-databases | gzip > /home/ssgconfig/<filename>.sql.gz

2. This will write the file to /home/ssgconfig but the location can be changed according to the requirement.