Knowledgebase

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).

Add to Favourites

Print this Article