Export data from mysql

I am practising the tutorial commands and getting the below mesage:
http://www.itversity.com/topic/creating-tables-in-hiveimpala/

Kindly advise

mysql> select * from categories into outfile ‘/tmp/categories01.csv’ fields terminated by ‘|’ lines terminated by ‘n’;
ERROR 1045 (28000): Access denied for user ‘retail_dba’@’%’ (using password: YES)
mysql> update mysql.user set file_priv = ‘Y’ where user = ‘retail_dba’;
ERROR 1142 (42000): UPDATE command denied to user ‘retail_dba’@‘gw01.itversity.com’ for table ‘user’

Hi acrajesh

did you performed the changes with the root user instead retail_dba user?

Regards.

Hi,

I am facing the below error while exporting from mysql. Please help.

select * from categories into outfile ‘/tmp/categories.psv’ fields terminated by ‘|’ lines terminated by ‘\n’;
ERROR 1045 (28000): Access denied for user ‘retail_dba’@’%’ (using password: YES)