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 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.

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.

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.

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.

Tips!

NOTE: The database name (which you will later use in your coding/scripts) takes the form of your-cpanel-username_database-name, for example (and following the video tutorial above) if your control panel username is mycpanel and the database name is number2, then the true database name for use in scripts/coding is gong to be mycpanel_number2. This allows you to connect and use the correct database in the MySQL database server.

NOTE: The database user (which you will later use in your coding/scripts) takes the form of your-cpanel-username_database-username, for example if your control panel username is mycpanel and the database username is second, then the true database username for use in scripts/coding is gong to be mycpanel_second. This allows you to connect and use the correct database in the MySQL database server.

Was this answer helpful?

 Print this Article

Also Read

How to Change the Look and Feel of your cPanel control panel

There are a number of different themes for your cPanel, you can change theme at any time You...

Generate and Import GnuPG Keys for secure communication

How to create and manage GnuPG Keys in your cPanel web hosting control panel   GnuPG...

Create a MySQL Database and add a user

At some point you will want to create and use MySQL databases for use in your web sites  ...

How to set up Hotlink Protection to prevent content misuse and bandwidth theft - video tutorial

Using Hotlink Protection in cPanel   How to set up Hotlink Protection to prevent other...

How to Change Your cPanel Password

This tutorial will teach you how to change your cPanel password. Please remember to make your...