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.

  • 11284 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

Becoming Familiar And Navigating Around in CPanel

Lets learn about cPanel, and how to navigate it's many pages and functions. Making sure that your...

How to Change Your cPanel Password

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

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

Change or Set Contact Information in cPanel

You must first log into your cPanel hosting control panel - if you have lost or forgotten your...

Create browser and desktop shortcuts for cPanel

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