MySQL® Manager

Valid for versions 94 through the latest version

Version:

94


Last modified: February 18, 2021

Overview

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

Warning:
  • This interface is experimental and is not fully functional. It only appears if you created the /var/cpanel/experimental/mysql_manager touch file.
  • Don’t use phpMyAdmin to create databases or database users. phpMyAdmin doesn’t map databases, which causes backups and restorations to not function.

The cPanel & WHM implementation of MySQL and MariaDB uses modified character limits for database names and database usernames:

A MySQL 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 uses two characters of the limit.
  • If your hosting provider enables database prefixing, a database name may contain a maximum of 63 characters, including the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.
  • To enter information in an existing database, or copy a database, use cPanel’s phpMyAdmin interface (cPanel >> Home >> Databases >> phpMyAdmin).

A MySQL username may only contain 16 characters. The system includes the database prefix (the first eight characters of the cPanel account’s username and an underscore (_) character) in the character count for the username. For example:

  • A MySQL database with the db_ prefix allows usernames that contain up to 13 characters.
  • A MySQL database with the example_ prefix allows usernames that contain up to eight characters.

MariaDB limits the database username to 47 characters. The system includes the database prefix (all of the cPanel account’s username and an underscore (_) character) in the character count for the username. For example:

  • A MariaDB database with the db_ prefix allows usernames that contain up to 44 characters.
  • A MariaDB database with the example_ prefix allows usernames that contain up to 39 characters.

The Databases tab

The Databases tab lists the databases owned by your cPanel account. To sort the database, click Database Name, Size, or Database User to reorder the Database table.

Create a Database and a Database User

The MySQL Manager interface will load the Create Database interface if your account does not have a database.

If your cPanel account already has a database, click Create Database to open the Create Database interface.

To create a database and database user, perform the following steps:

  1. In the Database Name text box, enter a name for the database.
  2. Click the Create Database user toggle to create a database user.
    • The interface will automatically enter a database username in the Database Username text box.
      • You can change the username in the Database Username text box. However, the system’s character modified limits still apply.
      • The interface will automatically assign the Select, Insert, Update, and Delete database privileges.
      • For more information about user privileges, read the MySQL documentation.
  3. Click Create.
    • If you wish to create multiple databases, click the Stay on this page to create another database checkbox.
    • Otherwise, the system will load the Databases table and your database will appear in the table.

View

The database table displays the following information for each database:

  • Database Name — The name of the database.
  • Size — The size of the database in bytes.
  • Database Users — The database users that you assigned permissions for the database.

Actions

You can use the following features for each database:

  • Manage — Change a database name.
    • To rename a database, click Manage. A new interface will appear. In the Database Name text box, enter the new database name and click Update to update the database name or Go Back to cancel.
  • Delete — Delete the database.
    • To delete a database, click Delete. A confirmation message will appear. Click Delete to delete the database or click Cancel.

The Database Users tab

This function is not yet implemented.

The Configuration tab

This function is not yet implemented.

Additional Documentation