Creating MySQL databases

(cPanel) To create a MySQL database:

  • Go to MySQL Databases in your cPanel
  • Under 'Create New Database', enter the database name you wish to use
  • Select 'Create Database'

(DirectAdmin) To create a MySQL database:

  • Go to MySQL Management in your DirectAdmin
  • Click 'Create New Database' button at the top of the page
  • Enter database name and user
  • Click 'Create Database'

Your full database name and database user name will have your cPanel/DirectAdmin username and an underscore appended to the beginning of the database name / user name you enter. 

Example:

If the username for your account is "domainc" and you have created a database named "phpbb" and a database user named "bbuser" then the correct database and database user names will be as follows:

database = domainc_phpbb
database user = domainc_bbuser


For further information:
Please refer to the cPanel documentation for database features, here.

  • 28 Users Found This Useful
Was this answer helpful?

Related Articles

Cron Jobs

Cron Jobs are a utility designed to execute programs (usually maintainence tasks) automatically...

Is ImageMagick available at HostRocket?

Yes. We can install ImageMagick on any/all servers upon request, and most of our servers already...

What is phpMyAdmin and how do I access it?

phpMyAdmin is a PHP-based MySQL database administration utility which can be used to modify and...

Why am I receiving a 'Cannot Connect to Database' error?

Receiving a 'Cannot Connect to Database' error indicates that the database settings entered in...

Using PHP 5.3 or Prior

While our shared servers do allow for the selection of multiple PHP versions, we highly recommend...