How to give file permission to user in Managed Mysql

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

Submit an answer
Answer a question...

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!

Sign In or Sign Up to Answer

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.

Bobby Iliev
Site Moderator
Site Moderator badge
June 15, 2022

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.