MySQL :: Creating Databases, Users and Assigning Permissions

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

Was this answer helpful?

 Print this Article

Also Read

FAQ: phpMyAdmin doesn't give the option to create a database

phpMyAdmin in a cPanel environment is designed for managing databases, not creating them. To...