, 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 and GLOBAL PRIVILEGES
mysql
I don't understand this message. Doesn't the on netscore.* clause
mean I'm setting privileges
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 and GLOBAL PRIVILEGES
mysql
FILE is a global privilege (it's recorded only in the user
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's
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