MySQL Databases

Overview

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

Notes:

• 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).

Important:

Do not use phpMyAdmin to create databases or database users.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Add a MySQL user

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

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...

Create a database

To create a database, perform the following steps: 1. In the New Database text box, enter a name...

Current Users

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

Current Databases

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

Powered by WHMCompleteSolution