How To Create A MySQL Database

On the main cPanel page, scroll down to the Database section, and click on the MySQL Databases icon. This will take you to the main MySQL Databases page. There is a box below the heading Create New Database. Type the name of your new database into this box. For example, something like myinfo, or mydata. Then click on Create Database button. This will take you to the verification screen, showing that the database has been created. Now you need to create and add a user to this database. Click the Go Back link.

Under the heading of Add New User, enter a new user to be added to your database in the Username box. You then need to enter and re- enter a password for the user. Click on the Create User button. This takes you to a screen to confirm that the user has been successfully created. Now you need to link the user to the database. Click on the Go Back link.

In the section where it says Add User to Database, check to make sure that the correct user and the correct database are selected here. NOTE: You will see that the username of the hosting account has been added to the beginning of both the user and the database with an "_" underscore between them. If the user and database are both correct, click on Submit to add the user to the database.

This will take you to a screen called Manage User Privileges. You can assign All Privileges to the user by checking the top box, then click Make Changes. This will take you to the final verification screen, that will confirm all the information.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Becoming familiar with databases in phpMyAdmin

The main screen is divided into two screens. In the blue section on the left, you can see any...

Copying a database table with phpMyAdmin

The phpMyAdmin page is divided into two main parts. The left blue screen is where you will find...

Creating tables in a database with phpMyAdmin

Start by selecting the database in the blue section that needs a table. Click on it. In the right...

Deleting fields from database tables with phpMyAdmin

For the purpose of this tutorial, we will use a database with one table for an example. The...

Deleting tables in a database with phpMyAdmin

For this tutorial, we will be using a database with two tables for the example. In the left hand...

Powered by WHMCompleteSolution