Creating a Database in cPanel

MySQL databases are used by many scripts such as WordPress to store information. Luckly cPanel makes creating databases very easy!

1. Login into your cPanel control panel and click on MySQL Databases icon. This is located in Databases section, the same section where phpMyAdmin button is at.

2. Next you need to name your database. Database name must consist of alphanumeric characters only, so no special signs like hash tags. Once you named it, create on Create Database button.

3. You should now see a message that database has been created successfully. Press on "

4. Now you need to create a new database user or assign an existing one to recently created database. Scroll down a little bit and you should see an "Add New User" section. Choose username and password and press on Create User.

5. Once the database username was created or you chose to use an existing user, you will need to assign the user to our database. Below "Add New User" section, you should see "Add User To Database". Select the user you want to assign and database you created and press "Add".

6. On the next screen you will be asked to give the corresponding database privileges to your user. Just tick "All Privileges" box and press "Make Changes".

  • 0 istifadəçi bunu faydalı hesab edir
Bu cavab sizə kömək etdi?

Uyğun məqalələr

How to change the database password

MySQL database passwords cannot be changed. You will need to create a new user and assign it to...

How to Export a Database

To export your MySQL database, follow the steps below: 1. Login in your cPanel 2. Click on...

How to Import a Database

To import your MySQL database follow the steps below: 1. Login in your cPanel 2. Click on...

Optimize a Database

Optimize Table should be used if you have deleted a large part of a table or if you have made...

Powered by WHMCompleteSolution