My HP

Creating a MySql Database

If your website uses PHP or you need to hold a collection of records which need to be accessed for parts of your website to work, you will need to create a database.


The first step is to log into your cPanel account. If you are unsure on how to do this, please view the following help article - 'How to log into cPanel'.

alt text

Scroll down to the 'Databases' section and choose 'MySQL Database Wizard'.

alt text

The first step is to write in a database name where 'New Database' is shown. This name will be prefixed on the end of your account name.

alt text

Select 'Next Step' button to continue.

alt text

You now need to set up a database username and password.

Type in:

  • Username - the username for the database user.
  • Password - password for the database user. You can take advantage of the 'Password Generator' option if this helps.
  • Password (Again) - repeat of the password.
You may wish to note down your database name, the database username and password.
alt text

Once the database user information has been completed, select 'Create User' button to proceed.

alt text

You now need to choose the database user privileges according to your requirements (usually 'all privileges').

alt text

Once the privileges have been set, choose 'Next Step' to complete the process.

alt text

You will now see visual confirmation that the database has been created.

alt text

Creating a MySQL database is now complete.