Set File_Priv = 'Y' for retail_dba user in MySQL

Durga, Could you please update mysq.user table and Set File_Priv = ‘Y’ for retail_dba user in MySQL? We cannot access as root to update this.


Why do you need this?

To create PST datafiles from mysql tables.

U can import the from mysql to hdfs using ‘|’ delimiter and copy to local and use it.

Dude, I know I can do it that way but I wanted to try it directly from the mysql table using SELECT … INTO OUTFILE option.

This is not mysql lab. We are in the process of setting up new databases. We will grant permissions on the new databases.