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]

Reply via email to