I'm using mysql 3.23.58 on linux. I recently upgraded from RedHat 9 to Fedora 3 and now I am unable to write to an outfile.
If I have started mysql with the simple "mysql" I get 'access denied' even if I am trying to put it into my home directory. mysql> select lname,fname,mname,addr,city,stzip from 1950class3 into outfile '/usr/class3-2'; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) mysql> If I have started with "mysql -u root -p" and then a password, I get 'Can't create file.' mysql> select lname, fname, addr,city,stzip from 1950class2 into outfile '/usr/database3-2'; ERROR 1: Can't create/write to file '/usr/database3-2' (Errcode: 13) mysql> bruce has all privileges on the table. How can I get my data out? bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]