How to create a MySQL database

To create a new MySQL database, you can use a the MySQL Database Wizard from cPanel.
  1. In the New Database text box, enter a name for the database.
  2. Click Next Step.
  3. In the Username text box, enter a name for the user who is allowed to manage the database.
  4. Enter and confirm the new password in the appropriate text boxes.Click Create User.
  5. Click Create User.
  6. Select the privileges that you want to grant the user, or select ALL PRIVILEGES.
  7. Click Next Step.
Next, cPanel will display a message that states that the database and user account were set up successfully.

Select one of the following three options:
  • Add another database — Returns to the start of the MySQL Database Wizard.
  • Add another user using the MySQL Databases Area — Opens the MySQL® Databases page, where you may create additional user accounts and assign them to a database.
  • Return to Home
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What database settings do I use for scripts?

Server Hostname: localhost Database Username: <your username>_<database name> e.g....

How do I add a wildcard subdomain for Wordpress MU?

This can be easily done by logging into your cPanel control panel and clicking on "Subdomains"....

Do you support Silverstripe Hosting?

Yes, we run Linux servers designed to run the New Zealand developed Silverstripe application. If...

Strict Standards Errors for PHP

If you are getting errors similar to:Strict Standards: Non-static method JLoader::import() should...

Fix permissions of all directories and files

To change all the directories to 755 (-rwxr-xr-x): find /home/xxx/public_html -type d -exec...