Create and manage MySQL Databases using the Wizard in cPanel

 

cPanel offers a step by step way to add and manage MySQL databases in your hosting account.

 

You must first log into your cPanel hosting control panel - if you have lost or forgotten your username and/or password, you must email support and ask for the details (lost passwords will mean a password reset).

Once logged in, we will proceed with using the MySQL Database Wizard in your cPanel web hosting control panel...

cpanel video tutorial view the MySQL Wizard video tutorial

 

 

First, click on the MySQL Wizard icon MySQL Wizard icon in the Domains section

We will arrive at the MySQL Database Wizard page . Here we are faced with the first step in creating a database using the wizard.

Step 1

Now we need to provide the name of the Database in the entry box titled 'New Database'. This can be any name you choose but must only consist of letters and numerals. We'll follow the video tutorial above and use the examples given there, so in this case we are using a database name of thenewdb. Click the 'Next Step' button to proceed.

Step 2

Now we arrive at the 'Create Database Users' page. Now that we have added the database using step 1, we must add one or more users to that database. A user does not necessarily represent an actual person, it is simply a username and password normally used in scripts to access, read and write to the database. Again, usernames can only consist of letter and/or numerals. So, following the video tutorial we enter the username and password in the entry boxes provided. In this case we are using quser as the username. Pay particular attention to the password strength meter when you provide the password, always attempt to achieve a strength of Very Strong to ensure a good level of security. Now click the 'Next Step' button.

Step 3

Now that we have created the database and user, we need to add the user to the database. On this page we can select the privileges that we want the user to have with the database. It is usual to have at least one user who has All Privileges to allow writing, reading and management of the database, so select All Privileges and then click the Next Step button to complete this stage.

We've now completed the MySQL Database Wizard. The database has been created, the user created and then added to the database. The next page confirms this information and gives us the opportunity to continue with the wizard to create another database.