-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jeff McKeon wrote:
> Ok, I've got FILE priv set on my user now, it had to use
>
> GRANT FILE ON *.*
>
> As it appears the FILE prive isn't a db level priv?
>
> Still getting the same results though, can't write the file...
>
> ERROR 1 at line 1: Can't create/write to file '/home/MIS/shiplist.csv'
> (Errcode: 13)
That means the user that the mysql server is running as (usually
'mysql') doesn't have write access to /home/MIS. You'll need to have the
'outfile' be somewhere that 'mysql' has write access to...(like /tmp,
but beware of the security implications that may/may not have in your
particular setup)...
(Error #13 is 'Access Denied' on Unix).
-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/BEYKtvXNTca6JD8RAhsZAJ9cKMcMqpGPZTN7LCvVJtvqkx8j1gCeOufa
huySMaw0Z8upXSL5bfUusig=
=Ay2k
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
