How do I create a database user and add it to a database?

Some types of websites (for example WordPress) work with a database to store you content and generate information. Once you have created a database, you will then need to create a user and then grant this user access to the database.

For steps on how to do this, please see the following.

First, to create a database user:

  1. Log in to your LetsHost client area and click on Services > My Services
  2. You will see your products/services listed out here. Click on Active beside your hosting package
  3. On the menu on the left, click on Login to cPanel
  4. Once logged in to your cPanel control panel, click on the icon for MySQL Databases
  5. Scroll down to MySQL Users
  6. Under Add New User fill in the username and password and click Create User. Please note the password set as you will need this when setting up your script or content management system.

Then, you will need to add the user to the database, click Go Back:

  1. Scroll down to MySQL Users
  2. Under Add User To Database, select the username and database and click Add
  3. You will be brought to the Manage User Privileges screen. Select All Privileges, or the ones recommended in your CMS installation guide
  4. Click Make Changes to add the user to the database

 

  • #database, #user, #add, #create
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How do I allow remote access to my MySQL database?

To allow remote access to your database, you will need to do this via the cPanel control panel....

How do I create a database?

Databases are used to store data for your website or content management system (such as...

How do I backup MySQL databases in cPanel?

To download a backup of your database, you will need to do this via the cPanel control panel....

How can I import my MySQL database to my hosting account?

To import an SQL file into a MySQL database, please see the following steps. Please note that...

How do I export my database from cPanel

If you wish to export your database from your cPanel hosting account (for the purposes of backups...