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.

Leave a Reply

Your email address will not be published. Required fields are marked *