Question
How to give file permission to user in Managed Mysql
- Posted on June 14, 2022
- DigitalOcean Managed MySQL DatabaseMySQL
Asked by Vaibhav Chauhan
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
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Hey @vaibhavchauhan,
I believe that you are getting that error as the FILE permission actually grants access to the filesystem on the server itself which is most likely restricted on the managed database clusters.
You could try reaching out to the DigitalOcean support team who might be able to grant you that specific privilege though there is a chance that this might not be doable:
Hope that helps!
- Bobby.