MySQL 5.6 Mysqldump error : Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1':

Are you getting this below error in MySQL 5.6. while taking backup:

mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)


Solution:

Use the mysqldump path to resolve this issue.

#usr/local/mysql/bin/mysqldump -u root -p --all-databases > databases.sql.


Now its solved.