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

 

 

 

 

Top