Error While Exporting Tables

by Aug 1, 2013



I am trying to export table data from uptime database and to a text file . But I am receiving following error while trying export the table data any clue why


I am able to query database and view the table , but my requirement to collect the content from the table.


mysql> SELECT * FROM entity INTO OUTFILE ‘/opt/uptime/mysql/entity.txt';

ERROR 1045 (28000): Access denied for user ‘uptime’@’localhost’ (using password: YES)


Please help me