DEV Community

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

Posted on • Updated 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💻

Top comments (0)