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
ata' into table boat; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) mysql> I tried to do a "grant file", but get a "wrong usage" error: [EMAIL PROTECTED] schema]$ mysql -u root -p -s Enter password: mysql> grant file on netscore.* to

Wrong usage of DB GRANT and GLOBAL PRIVILEGES

2003-09-12 Thread Roy Smith
denied for user: '[EMAIL PROTECTED]' (Using password: NO) mysql> I tried to do a "grant file", but get a "wrong usage" error: [EMAIL PROTECTED] schema]$ mysql -u root -p -s Enter password: mysql> grant file on netscore.* to roy; ERROR 1221: Wrong usage of DB GRANT