The default user provided when the database is created doadmin has no privileges. When trying to run this command:
GRANT ALL PRIVILEGES ON database_name.* TO 'new_user'@'%';
I get this error:
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
and I get a similar error when trying to give doadmin user privileges.
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!
Hi @mahdyhamad45Ray,
I Assume you are using MySQL managed database. Are you running GRANT ALL with ‘doadmin’ user? If not suggest you execute using ‘doadmin’ user account.
The Below documentation can guide you:
I hope this helps!
Regards, Rajkishore
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.