Question

Creating a user and granting privileges to the user

Posted December 27, 2019 164 views
DigitalOcean Managed MySQL Database

Hi All,

This is how the use case goes.

I have to create a new database, a new user and grant privileges to the newly created user for the db which i just created.

The problem is that i am not able to grant the privileges as it says access denied to user.

My first problem:- How do i grant a root access to a user which i created from the dashboard.

If not root user:- How do i get the root credentials to make a new user.

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.

×
1 answer

This is not possible with the Managed databases, if they allow you to have root access to the managed cluster then the cluster would no longer be managed as a user can make all kinds of changes and break the cluster.

Submit an Answer