MySQL - How to grant FILE privilege?
I am running MySQL 4.0.20-0.What is the syntax to grant FILE privele to a specific user for a specific database?
Following does not work;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,FILE ON db_name.* TO 'mysql_user'@'localhost'
IDENTIFIED BY 'passwd';
flush privileges;
Get this error;
ERROR 1221: Wrong usage of DB GRANT and GLOBAL PRIVILEGES