Re: Wrong usage of DB GRANT and GLOBAL PRIVILEGES

2003-09-12 Thread Paul DuBois
At 10:32 PM -0400 9/12/03, Roy Smith wrote: On Friday, September 12, 2003, at 10:24 PM, Paul DuBois wrote: FILE is a global privilege (it's recorded only in the user table) and must be granted at that level: GRANT FILE ON *.* TO 'roy'@'localhost'; Ah. That makes sense. Thanks. I'm not sure why

Re: Wrong usage of DB GRANT and GLOBAL PRIVILEGES

2003-09-12 Thread Roy Smith
On Friday, September 12, 2003, at 10:24 PM, Paul DuBois wrote: FILE is a global privilege (it's recorded only in the user table) and must be granted at that level: GRANT FILE ON *.* TO 'roy'@'localhost'; Ah. That makes sense. Thanks. I'm not sure why you're trying to grant to just "roy". That'

Re: Wrong usage of DB GRANT and GLOBAL PRIVILEGES

2003-09-12 Thread Paul DuBois
At 8:59 PM -0400 9/12/03, Roy Smith wrote: I'm running mysql-standard-4.0.14-pc-linux-i686. I've got a database netscore which I want to be able to bulk load. The database already exists and I can do inserts into tables: [EMAIL PROTECTED] schema]$ mysql -s mysql> use netscore mysql> insert into