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

Setting up easy webmail (Horde) access on CPanel (Views: 6968)

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

How do I access / read / delete my spam folder on CPanel ? (Views: 10398)

What is the path to ImageMagick ? Where is ImageMagik ? (Views: 3227)

How do I set the database permissions for a Microsoft Access file (*.mdb) on Windows Plesk. (Views: 3120)