ccihosting.com
Have questions? Call us.
Panama: (+507) 264.0852

cPanel and MySQL

CCIHosting.com knowledgebase

Knowledgebase

How to create a MySQL database in cPanel

To create a database, perform the following steps:
  1. In the New Database text box, enter a name for the database.Note:If your hosting provider has enabled database prefixing, up to the first eight characters of your cPanel account username and an underscore character (_) will precede the New Database text box. The system automatically prepends the database name that you enter with this prefix.
  2. Click Create Database. A new interface will appear.
  3. Click Go Back. The new database appears in the Current Databases table.

Modify Databases

Check a database

If you experience problems with a database on your server, check your databases for errors. To check a database for errors, perform the following steps:
  1. In the Check Database menu, select the database that you wish to check.
  2. Click Check Database. A new interface will appear, and the system will check whether the database functions correctly.
    • If the system detects a problem in the database, it displays the name of the corrupt table.
    • If the Check Complete message displays, the database functions correctly.
  3. Click Go Back to return to the main interface.

Repair a database

If one of your databases is corrupt, you can attempt to repair it. To repair a database, perform the following steps:
  1. In the Repair Database menu, select the database that you wish to repair.
  2. Click Repair Database. A new interface will appear, and the system will attempt to automatically repair the database.
    1. If the system cannot repair the database, it will attempt to determine the source of the corrupt data.
    2. If the Repair Complete message displays, the system successfully repaired the database.
  3. Click Go Back to return to the main interface.

Need a Web Hosting account?

Web Hosting

$ 6/month
Starting at

View Plans

  • Instant Activation
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted

VPS

$ 15/month
Starting at

View Plans

  • Instant Activation
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted

Cloud Servers

$ 35/month
Starting at

View Plans

  • Instant Activation
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted

Dedicated Servers

$ 90/month
Starting at

View Plans

  • 48 Hours or Less
  • DDoS Protection
  • 24x7 Tech Support
  • Bitcoin Accepted
paypal
visa
mastercard
bitcoin

Need assistance choosing your right server? We are here to help

Call our sales team at +(507) 264.0852 or talk with us on Live Chat