1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
Hey, i got error message ” 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES”.
My Command was:
GRANT FILE ON DB.* TO ‘feed’@’localhost IDENTIFIED BY ‘user’;
After googling i cme to know that “the FILE privileges are global and cannot be applied to a single database”
So correct SQL Statement is:
GRANT FILE ON *.* to user@localhost;
Categories: General
Leave a reply to Rad Cancel reply
Recent Comments
 | preetul on Fish names in English and… |
 | Sanjeev Gayachari on Fish names in English and… |
 | Suraj Patil on Fish names in English and… |
 | Rekha Dingankar on Fish names in English and… |
 | Rajkisan Deshmukh on Fish names in English and… |
What I have written I have written. 
thank you
Super thanks !
Thank you. All I needed.
Thank you.
had this same problem when issueing: grant replication slave on my_db.* to ‘replication’@’my_host_ip’;
issuing the following fixed this mysql error: rant replication slave on *.* to ‘replication’@’my_host_ip’;
thank you for your post!
Just thank you!!:)
Thanks that was fast
Thank you very much. I had a similar problem with granting SUPER privileges to a user. *.* fixed the issue
GRANT SUPER ON *.* to ‘user’@’host’
THANKS 🙂 Sharing is wunderbar.
Thanks!
thks, very usefull
Thanks, the same to you
Thanks!