Creating MYSQL Databases
MySQL Databases are used by script applications such as Forums, Shopping Carts and CMS Systems like Wordpress or Drupal. Most popular scripts can be installed using the Script Installer which will automatically generate and configure any Databases required.
If you are installing your own scripts that require MySQL then you should use the MySQL Wizard Icon in your cPanel.
Create a new MySQL database
If you want to view the current MySQL Databases and Database Users and perform DB Index Checks and Repairs then you should use the MySQL Database Icon in your cPanel.
Check a MySQL database for errors or corruption
Repair a MySQL database with errors or corruption
Delete a MySQL database
Add a new MySQL user
You will need to create MySQL user accounts separately from mail and web administrator accounts.
Add a MySQL user to a MySQL database
For a user to be able to access a database, you will need to assign the user to the database.
Delete a MySQL user
Delete a MySQL user from a specific database
PhpMyAdmin To Edit Your Databases
If you need to manually edit your Database you can use the PhpMyadmin tool located in your cPanel.
*** Note PhpMyadmin uses your cPanel login to define permissions so you must be logged directly into your cpanel not your master account or it will not be able to access the database. You can find your direct cPanel credentials via your Account portal under services / MyServices / View Details / Change Password tab.
Using PHP My Admin To Manage Your Database
For additional help using PhpMyadmin see their website.
Using Your MySQL Databases
When installing a script on your server it will ask you to supply the Database Credentials:
1. Database Name: this will be the name as specified by cpanel in format user_dbname
2. Database User: this will be the user name specified when the DB was created
3. Host: this will always be localhost for any script that runs on the server
4. Password: what ever password you specified when creating the database
I Lost my Database password?
Database passwords are encrypted on the server. You can generally find them out by analyzing the configuration files for your scripts that call the database. If you have difficulty open a Support Ticket and specify the script name and database name, and our staff will attempt to retrieve it for you.