Creating a Database
- Click on MySQL Databases in your control panel.
- Create a name for the new database, and click Add DB.
- The database name will be of the format <username>_<database name>.
Creating a User (for you or your scripts)
- Click on MySQL Databases in your control panel.
- Create a user and password and click Add User.
- The user name will be of the format <username>_<user>.
Note: At this point you have a database and a user, but the user has no permission to access this database (remember this user is your script - so they will need access!)
Assigning Permissions
- Click on MySQL Databases in your control panel.
- Select the username and database in the drop-down menus.
- Assign the appropriate user privileges.
- Click Add User To DB.
- cPanel will now give you a list of example connection strings for connecting to your database (Perl, PHP and JDBC).
