Creating MySQL Database and User

Creating a MySQL database with cPanel can be easily accomplished. In order to create a MySQL database on your hosting account, you need to log in to the cPanel. This can be done by either using the Go button in the Customer Area ->My Account Account section:

mysql01.jpg

or by entering the following URL in your Web Browser:

http://yourdomainname.com/cpanel
http://cpanel.servername.com

You should replace "yourdomainname.com" with your actual Domain Name or "servername.com" with the hostname of the AVHoster Server on which your account is hosted.

Once you have logged in the cPanel, you can access the MySQL management screen by clicking on the MySQL Databases button as shown below.

mysql02.jpg


In order to create a new database you need to enter the desired name for the database in the New Database field and click on the Create Database button as shown below:

mysql03.jpg


A confirmation screen will be displayed, informing that the database has been successfully created:

mysql04.jpg


You can click on the Go Back button to return to the database management screen.

The MySQL database is created with your username as prefix - username_databasename and this is the name you have to use for your application.

Creating a MySQL Username Detailed Tutorial


You can continue with the creation of a user who should be able to connect to the newly created database. To create a user you just need to fill in the desired user name and password as shown in the image below:

mysql05.jpg



Click Submit to save your MySQL username.

You should always bear in mind that your cPanel username will be added as a prefix to all databases and usernames you create.

Adding a user to a MySQL Database Detailed Tutorial


Once the database and the username are created, you can add certain privileges for the user to the database. In order to do so you should select them both from the corresponding drop-down menus under Add User To Database label and click on the Submit button:

mysql06.jpg


You will be redirected to a screen where you will be prompted to choose the desired privileges. It is advisable to select All Privileges and click on the Make Changes button:

mysql07.jpg

 

Using the MySQL Database Wizard


All of the steps above can be accomplished using the MySQL Database Wizard. Click on it and you will be guided through all steps that you should perform in order to successfully create a new MySQL database and add a user to it.

mysql08.jpg
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Domains - Add-on Domains

Through the Addon Domains feature, you can add addon domains to your account. An addon domain...

Advanced Section

In the Advanced section, there are several tools which functionality will be described in the...

Advanced (UNIX Style) Cron Jobs Mod

Advanced (UNIX Style) Cron Jobs Mod This provides the regular UNIX style cron options. It is...

Files section in cPanel

Files section in cPanel    File Manager - allows you to manage your site through HTTP rather...

File Manager Detailed Tutorial

The File Manager allows you to manage your site through HTTP rather than an FTP tool or other...