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.

  • 4 Users Found This Useful
這篇文章有幫助嗎?

相關文章

Do your CPanel hosting accounts come with BoxTrapper ?

At present we do not offer a BoxTrapper based spam prevention solution. BoxTrapper is based...

How do I access the CPanel control panel ?

Your CPanel control panel is accessed by a web browser at http://{domain}/cpanel i.e. if your...

Setting up easy webmail (Horde) access on CPanel

Alternative ways of accessing webmail ... Our standard CPanel method of accessing the webmail...

Cannot publish site with Frontpage Extensions, front page reporting incorrect password

Problem: I can no longer publish a site with Frontpage Extensions it says I have the wrong...

What is the server path to my files ?

The path to your files will vary depending on the control panel you use... Plesk (linux)...

Powered by WHMCompleteSolution