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'.
Scroll down to the '
Databases' section and choose '
MySQL Database Wizard'.
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.
Select '
Next Step' button to continue.
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.
Once the database user information has been completed, select '
Create User' button to proceed.
You now need to choose the database user privileges according to your requirements (usually 'all privileges').
Once the privileges have been set, choose '
Next Step' to complete the process.
You will now see visual confirmation that the database has been created.
Creating a MySQL database is now complete.