Knowledgebase

How do I create a MySQL database in Cpanel ?

MySQL databases can be created through the cpanel control panel:

1. Login to your control panel
2. Click on the MySQL Databases icon.
   This may be under the Server or Database sections depending on the theme of your control panel
3. Enter a name for your database in the Db input field
   Click the Add Db button.
4. Go back to the MySQL Administration page by clicking the go back link
5. Scroll down to where it says Database Users and create a new username and password for your database
   Click the Add User button.
6. Go back to the MySQL Administration page by clicking the go back link
7. Scroll down to where it says Database Users and select the new user and the database
   Click the Add User to DB button.

Remember:Your cpanel username is used as a prefix to databases and database users.
So if you created a database named mydb for access by your cgi scripts and applications it\'s actually going to be called cpaneluser_mydb. Similarly with database users.

Details of the MySQL DB and DB User can be seen in the control panel in the MySQL Administration page.

You may add MySQL Databases and Users as long as there are remaining resources available in your hosting plan.

Add to Favourites    Print this Article

DSNless connection to MS Access (Views: 2313)

How to Uninstall / Remove Applications with Softaculous? (Views: 2413)

How do I stop Cpanel reporting /usr/bin/crontab permissions are wrong. Please set to 4755. (Views: 3062)

How do I setup an Out Of Office Autoreply on Astutium WebMail (Views: 1369)

How do I move a MySQL Database from one host to another using phpMyAdmin ? Backup and Restore using phpMyAdmin. (Views: 16026)