You have to enable the file_permission for the user in order to create file.
On 3/3/06, Bruce Bales <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
