I want to do some file operations on my managed mysql. I tried adding privileges using
GRANT ALL ON testdb.* TO 'sammy'@'%' WITH GRANT OPTION;
but this does not do the trick.
I also tried
grant file on testdb.* to 'sammy'@'%' WITH GRANT OPTION;
This returns an error- Error Code: 1227. Access denied; you need (at least one of) the FILE privilege(s) for this operation
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.