Setting Up a Database

To setup a database:
  1. Login into your cPanel.
  2. Click on "MySQL Databases".
  3. Click on the Add Db button.
    You need to create at least one database user and grant that user permission to use the new database.
You need to create a MySQL user before that user is able to use the database. This does not automatically allow the user to use a database – you need to grant that user permission to the specific database first.
To create a MySQL user:
  1. Click on the MySQL databases button on the home page.
  2.  Enter the user’s name in the UserName field and the user’s password in the Password field.
  3. Click on the Add User button.
Once you have created a user to use a database you need to grant that user permission to use the database.
To grant user permissions to a MySQL database:

  1. Click on the MySQL databases button on the home page.
  2. Choose the specific user from the User drop-down list and the specific database to grant permissions to from the Db drop-down list.
  3. Click on the Add User to Db button. The user now has permission to use that database and sample connection strings are shown in the MySQL window.