Creating a user and granting privileges to the user

Posted December 27, 2019 3.3k 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.

Submit an Answer
2 answers

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.

You can do this from any database tool or command line tool. How To Create a New User and Grant Permissions in MySQL

by Etel Sverdlov
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to to create new MySQL users and how to grant them the appropriate permissions.