Filed under:

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.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
article icon What is MySQL? (Views: 2466)

Language: