MyBestRatedWebHosting's MBRW Second Semi-Annual 2011 Hosting Award has been officially announced! Save yourself time and money by reading our detailed review and learn who received the final award of the industry's best web host!

MyBestRatedWebhosting.com

How to Create MySQL Databases in cPanel

How to Create MySQL Databases in cPanel

Databases are very useful as they allow you to store and easily access vital information. The most popular of all, MySQL databases, are used to provide back-end support for web hosting features that range from shopping cart software to content management systems. Although databases are often automatically created with a one-click installer such as Fantastico, it is still a plus if you know how to manually create them for other purposes. This tutorial will show you how to do just that from within cPanel.

cPanel allows you to create a MySQL database in two ways. The easiest method is through the MySQL Database Wizard built into the cPanel software.

Launching the Wizard

  • From the main page of cPanel, locate and click on the “MySQL Database Wizard” under the “Database” section.
  • On the next page, you will be prompted to enter the name for your database in the “New Database” text field.
  • After entering the name, click the “Next Step” button.

On the next page, you will be greeted with a message that reads: “Added the database your_database_name. You will then be prompted to enter the following information:

– Username – The username that will be associated with this particular database
– Password – The password that will be associated with this particular database
– Password (Again) – A confirmation of the password that was associated with your database

– After entering the required information, click on the “Next Step” button. You will then see a message giving notification of the username and password you just added.

On the next page, there will be an area consisting of two tables. The top portion has an “All Privileges” option which allows you to grant all privileges to the database user. The other options include:

Select – Allows the user to choose data from tables in the database
Insert – Allows the user to insert data into tables in the database
Updates – Allows the user to update data in table in the database
Delete – Allows the user to delete data from tables in the database
Index – Allows the user to create an index of table columns in the database
Create – Allows the user to create tables in the database
Alter – Allows the user to modify tables in the database
Drop – Allows the user to drop tables in the database
Lock tables – Allows the user to drop tables in the database
References – Allows the user to create references to tables in the database

– If you do not need specific control over the database, simple check the “All Privileges” option. If you do, make the appropriate selections from the list of options above.

– After making your selection(s), click the “Next Step” button.

Wrapping Up

You will then see a message displaying the username that was added to the database. From here, you will have the option of creating another database or adding another user to the database you just created. If you are done, simply click the “Return to Home” link to return to the cPanel main page.

Creating a MySQL database in cPanel is a simple process that can be done in a matter of minutes.

Related Articles

  • Top 5 cPanel Hosts
  • All MBRW cPanel Tutorials
  • Be Sociable, Share!
    « »
    24th March 2009
    Posted by Web Hosting Consultant in MBRW cPanel Tutorials

    Submit your Review