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 the same as 'roy'@'%'. Is that how your account is actually set up?
Yes. I've got a bit of a toy environment, on a secure network, for educational purposes, so I havn't really given much thought to this kind of stuff.
Okay. Then the GRANT statement I showed should end in "TO 'roy'", not "TO 'roy'@'localhost'".
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
