Version 76 Documentation
Child pages
  • MySQL Databases

Versions Compared

Old Version 2

changes.mady.by.user Documentation

Saved on

compared with

New Version Current

changes.mady.by.user Documentation

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
LIB:_Version
LIB:_Version

(cPanel >> Home >> Databases >> MySQL Databases)

Overview

Use this interface to create, manage, and delete MySQL® databases and database users.

Warning
titleWarning:

Do not use phpMyAdmin to create databases or database users. phpMyAdmin does not map databases, which causes backups and restores to not function.


Note
titleNotes:
  • We recommend that you use the MySQL Database Wizard interface (cPanel >> Home >> Databases >> MySQL Database Wizard) to create your first database and user.
  • A database name may contain a maximum of 64 characters.
    • Due to the method that cPanel & WHM uses to store MySQL database names, each underscore character requires two characters of that limit.
    • If you enable database prefixing, a database name may contain a maximum of 63 characters, which includes the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.

  • To enter information in an existing database, use the phpMyAdmin interface (cPanel >> Home >> Databases >> phpMyAdmin).

Create a database

To create a database, perform the following steps:

  1. In the New Database text box, enter a name for the database.

    Note
    titleNote:

    If your hosting provider has enabled database prefixing, a prefix based on your account username and underscore character (_) will precede the New Database text box. The system automatically prepends this prefix to the database name.


  2. Click Create Database. A new interface will appear.
  3. Click Go Back. The new database appears in the Current Databases table.

Modify Databases

If you experience problems with a database, check your databases for errors.

Check a database

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.


Panel
borderColor#d9d9d9
bgColor#F2F2F2
borderStylesolid

In This Document

Toc no bullet
excludeDocument|Hosting

Related Documentation

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
operatorAND
cqllabel in ("mysql","databases") and label = "cpanel" and space = currentSpace()
labelsapiguide

For Hosting Providers

Content by Label
showLabelsfalse
max5
showSpacefalse
sortmodified
operatorAND
cqllabel in ("mysql","databases") and label = "whm" and space in (currentSpace(),"CKB","EA","EA4")
labelsapiguide


Repair a database

If one of your databases becomes 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.

Current Databases

The Current Databases table lists the following information for each database in your account:

  • Database — The name of the database.
  • Size — The size of the database.

  • Privileged Users — The users who can manipulate the database.

    Note
    titleNote:

    When you modify database users, make certain that you modify the user's access to the correct database. Users may have access to more than one database.

    • To remove a user from a database, click the trashcan icon () for the desired user, and then click Revoke User Privileges from Database.

    • To modify a user's privileges for a specific database, click the desired username, select and deselect checkboxes to configure the desired privileges, and then click Make Changes.
  • Actions — The available actions for this database. Click the appropriate icon in this column to rename or delete a database.

Rename a database

Warning
titleWarning:
  • It is potentially dangerous to rename a MySQL database. We strongly recommend that you perform a backup of the MySQL database before you attempt to rename it.
  • When you rename a database, the system terminates all active connections to the database.
  • You must manually update configuration files and applications to use the new database name.
  • The system requires more time to rename larger and more complex databases.

To rename a database, perform the following steps:

  1. In the Current Databases table, click Rename for the desired database.
  2. Enter the new database name in the New name text box.
  3. Click Proceed.

Include Page
LIB:_RenameDatabase
LIB:_RenameDatabase

Delete a database

To delete a database, perform the following steps:

  1. In the Current Databases table, click Delete for the desired database.
  2. To permanently delete the database, click Delete Database.
  3. Click Go Back to return to the main interface.

Add a MySQL user

After you create a database, add users to the database and configure their privileges.

Note
titleNotes:
  • You must create MySQL user accounts separately from mail and web administrator accounts.
  • You must create a user before you can add the user to an existing database.

To create a new user account, perform the following steps:

  1. Enter a username in the Username text box. 

    Include Page
    LIB:_MySQL Username Limit
    LIB:_MySQL Username Limit

  2. Include Page
    LIB:_Enter and confirm password and Notes
    LIB:_Enter and confirm password and Notes

  3. Click Create User.
  4. Click Go Back to return to the main interface.

Add a user to a database

To add a user to a database, perform the following steps:

  1. In the Add User To Database section of the interface, select the desired user and database from the menus.
  2. Click Add. The MySQL Account Maintenance interface will appear.

  3. Select the checkboxes that correspond to the privileges that you wish to grant to the user.

    Note
    titleNote:

    To grant all of the available privileges to the user, select the ALL PRIVILEGES checkbox.


  4. Click Make Changes.
  5. Click Go Back to return to the main interface.

For more information about user privileges, read the MySQL documentation.

Current Users

The Current Users table lists all of your MySQL database users, and allows you to perform the following actions:

  • Change Password — Click to modify a database user's password. Enter and confirm the desired password, and then click Change Password.
  • Rename — Click to rename a database user. Enter the desired username, and then click Change Username.
  • Delete — Click to permanently delete a database user, and then click Delete User to continue.