How to manage MySQL databases?

Managing you MySQL databases can be done online, using the cPanel's functionality. Just click on the MySQL Databases icon and you will be able to create and delete databases, manage their users, etc.

If you are willing to create a database, type the name in the space, labeled Db and click the Add Db button. To create a user, please provide a login and a password in the Users section below. To actually allow a user access databases select the two parties from the dropdown menus, the privileges you wish to grant to that user, and then click the Add Users to Db button.

To administer your databases in full while online, you can use the phpMyAdmin link at the bottom of the page.

If you wish to connect a script to a database, please make sure that:

1. Your database is created.

2. The user for the database exists.

3. The user is added to the database.

4. You are using the source code which is generated by cPanel to connect to your databases.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Upgrading Cpanel Pre-installed Scripts

To perform upgrade on the pre-installed scripts such as PHPNuke, AdvancedGuestBook, InvisionBoard...

How to create files and folders through the cPanel?

In order to create a new folder from your File Manager, please go to your www folder and click...

How to delete files and folders?

It is easy to delete a file, but sometimes it is not what you would like to actually do. In...

How to move and copy a file?

Sometimes you need to move files from one directory to another, or would like to make a copy...

How to rename a file?

Sometimes you want to have a newer version of a file uploaded in your webspace, while keeping...