Hello,
I have need to export the RECORDINGS table of the Rivendell database. I have
tried:
mysql select * from RECORDINGS INTO OUTFILE '/home/rd/Documents/Test.txt';
but got the error:
ERROR 1045 (28000): Access denied for user 'rduser'@'localhost' (using
password: YES)
We have over 1600
On Monday 29 December 2014 10:39:49 am Mike Price wrote:
I have need to export the RECORDINGS table of the Rivendell database. I have
tried:
mysql select * from RECORDINGS INTO OUTFILE '/home/rd/Documents/Test.txt';
but got the error:
ERROR 1045 (28000): Access denied for user
You need to assign file access for the MySQL rduser account to be able
to write files on the server. The Rivendell system doesn't set this grant
when creating the rduser account. See
http://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_file
Also note this comment from the MySQL