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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
