Adding User To MySQL Database In Linux Hosting

In the previous post, I have written about creating a MySQL database using control panel in linux hosting. Now lets see how to add users to the newly created database.

Here, two steps are involved. First is creating the user and second is adding the user to the database. So lets see how to do that.

#1. Creating MySQL User

  1. Login to your webhosting account.
  2. Go to control panel (cPanel).
  3. Select MySQL Databases
  4. Scroll down to MySQL Users
  5. Type in the desired username and password in the input form.
  6. And click on create user.
  7. This will create a new MySQL user.

But not that, this newly created MySQL user has no access to any MySQL database. So to associate this MySQL user to any database you’ll need to follow step 2.

MySQL Database

#2. Adding MySQL User To MySQL Database

Once you create a new user, stay on the same page and scroll down. You can see Add User To Database option. This is where you will have to select the User and select the Database from a drop down menu. After selecting the user and database, just click on Add button and you are good to go.

You can now use this newly created database for installing WordPress, Joomla, etc.

5 Replies to “Adding User To MySQL Database In Linux Hosting”

  1. you’re in point of fact a excellent webmaster.
    The web site loading velocity is incredible. It seems that you’re doing any
    unique trick. In addition, The contents are masterwork. you’ve performed a excellent task on this subject!

  2. I was very happy to discover this site. I want to to
    thank you for ones time just for this fantastic read!!

    I definitely appreciated every part of it and I have you saved
    to fav to see new information on your website.

Comments are closed.