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.

Creating New Database Using MySQL In Linux Hosting

In this post, I’ll be talking about how to create a MySQL database in Linux Web Hosting. This is actually very simple. First of all, login to your hosting account and open the control panel (cPanel).

In cPanel, navigate or scroll down to the databases section. Here select the MySQL databases option. And rest you can figure it out yourself. But if you can’t, then continue reading..

You can find a box which says ‘Create New Database‘. All you need to do over here is just enter the name of the database. And hit the ‘Create Database‘ Button.

Your database will be created. You can now use this database for WordPress, Joomla, etc. But you’ll need to add users to the newly created database. In the next post we’ll see how to add users to the MySQL database.