To create the database:In the New Database field, type a name for the database.
The new database will appear in the Current Databases table.
If you are experiencing problems using any database related software you have installed on the server, you may check your databases for errors.To check a database:
cPanel will run a script that checks to make sure the database is functional. The results will appear on a new screen.If cPanel detects a problem in the database, it will indicate which table is corrupted.If the Check Complete message appears without a notification that the database is corrupted, then the database is functional.
If you have checked a database and found an error, you will need to repair it.To repair a database:
Note: This will only attempt to repair the database. A repair may not be possible; in this case, you will be able to locate the source of the corrupt data.Create a Database UserAfter you create the database, you will need to add users and their privileges so that the database can be filled and managed. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.
To quickly access the MySQL Users interface, click Jump to MySQL Users.
Note: The password must be 7 letters or shorter.For help generating a strong password, click the Password Generator button.Retype the password in the Password (Again) field.Click Create User.
Privileges define how the user is able to interact with the database. For example, they will determine whether or not the user can add and delete information.To define a user’s privileges:
This table contains a list of databases on your server. For each database, the table displays:
To search the Current Databases table:
The table will display the search results.
To modify a user’s privileges for managing a database:
To disallow a user from managing a database:
To delete a database from the server:
To delete a MySQL user account:
To enter new information into a database, you can use the phpMyAdmin client installed with cPanel. For more information regarding phpMyAdmin visit http://www.phpmyadmin.net.original Cpanel documentation from http://docs.cpanel.net/
<< Go back