mysql ‘select … into outfile’ access denied

mysql’s ‘select … into outfile …’ is an easy way to export the results of a query to a file, but to execute this command you need the additional FILE privilege. The privilege is not granted by default, even with ALL, e.g. grant ALL on exampledb.* to exampleuser; The ALL privilege does not include FILE, … Continue reading mysql ‘select … into outfile’ access denied