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.