Which are the proper privileges to mysqldump for the Error Access denied when executing 'SELECT INTO OUTFILE'.? Which are the proper privileges to mysqldump for the Error Access denied when executing 'SELECT INTO OUTFILE'.? windows windows

Which are the proper privileges to mysqldump for the Error Access denied when executing 'SELECT INTO OUTFILE'.?


You need the FILE privilege in order to be allowed to use SELECT...INTO OUTFILE, which seems to be what mysqldump --tab uses to generate the tab-separated dump.

This privilege is global, which means it may only be granted "ON *.*" :

GRANT FILE ON *.* TO 'backup'@'%';