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 set up FTP

We've noticed that some new clients use FTP to begin with their sites. This is never a bad thing...

Password Protect Directories - restrict access to a folder

Control access to directories and files by using password protection on directories using cPanel...

How to configure your email program/client

Setting Up POP3 email access for cPanel   How to set up your email client for use with...

How to add another web site to your hosting account - creating an addon domain

Add another web site using Addon Domains in cPanel   You'll want to take advantage of the...

Create browser and desktop shortcuts for cPanel

Easily access your cPanel by adding cPanel shortcuts to your desktop or browser's bookmarks...