How do I create a MySQL database, a user, and then delete if needed? Print

If you are using any type of PHP software or keeping a collection of records which need to be accessed in some way, you will need to create a database. Below will show you how to create a MySQL database in cpanel.

Create DataBase:

1. Click the MySQL Databases icon
2. In the box to the right of New Database, please provide a name for the database. Please note cPanel will create the full name of the database as cpaneluser_databasename
3. Click the Create Database button

You have now successfully add the database, You will now need to crate a user to access the database.

Whenever you have any type of MySQL database, you will need to assign a user to be able to access the database. If you would like to create a user and give them access to the database, please do the following:

Create User:

1. Click MySQL Databases
2. Scroll down until you see the Current Users section
3. Under this section and to the right of User name, please provide a user name for a database
4. Please note that that full database user will be cpaneluser_databaseuser
5. To the right of Password, please type the password for which you would like to create for this database user.
6. Click Create User

You have now created a database user.