Re: File_priv syntax?

2004-01-16 Thread Tobias Asplund
On Fri, 16 Jan 2004, Jough P wrote: > Greetings all, I'm trying to grant a user the file privilege and am > getting error messages. Here's my SQL statement > > mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY > 'password123'; > > It gets the following error: > > ERROR 1144: Illeg

File_priv syntax?

2004-01-16 Thread Jough P
Greetings all, I'm trying to grant a user the file privelege and am getting error messages. Here's my SQL statement mysql> GRANT file ON bs.table1 TO [EMAIL PROTECTED] IDENTIFIED BY 'password123'; It gets the following error: ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual