DEV Community

Cover image for How to add user into Database and Manage Privileges
Osman Forhad
Osman Forhad

Posted on • Edited on

How to add user into Database and Manage Privileges

Few days ago, I was working with live hosting server which is basically called cPanel. So, I want to share this experience with all of you.
Recently I was developed a web application after successful testing in local environment. I need to deploy it on live hosting server. So how was the process being, don’t worry I’m going to clear about it.
For that first I go to my cPanel link which is like: https://mywbsite.com/cpanel now it’s shows me like below screen:

So, I need to submit my login credential for going to cPanel Dashboard

Alt Text

After login successfully it shows me cPanel Dashboard area it looks like below:
Alt Text
Now I am ready to go create database as mention my heading for that I need to click MySQL Databases from DATABASES area
Alt Text
It will redirect me another panel which is like below
Alt Text
Now it’s time to select Database user and Select the Database and click Add button.
It’s redirects me another panel which is like below:
Alt Text
In this panel I need to click ALL PRIVILEGES checkbox and then click to Make Changes Button. All done.
That’s it
.
Happy Coding.
osman forhad
Web & Mobile Application Developer💻

AWS GenAI LIVE image

Real challenges. Real solutions. Real talk.

From technical discussions to philosophical debates, AWS and AWS Partners examine the impact and evolution of gen AI.

Learn more

Top comments (0)

AWS GenAI LIVE image

How is generative AI increasing efficiency?

Join AWS GenAI LIVE! to find out how gen AI is reshaping productivity, streamlining processes, and driving innovation.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay