↩ MySQL Basics

Creating a database

There are two ways to create a new database from within cPanel. You can either use the "MySQL Database Wizard" and follow the on-screen instructions, or manually create the database as follows:

  1. From the main cPanel menu - 'MySQL Databases'
  2. Create the Database: Add a database name in the 'New Database:' box, then click 'Create Database'. Go back.
  3. Create the DB User: Add a database user in the 'UserName:' and 'Password:' boxes, then click 'Create User'. Go back.
  4. Add the User to the Database: Select the User and Db you just created from the "Add Users To Your Databases:" drop-down boxes, then click 'Add User to Database'

If the User and/or Db you have created do not appear in the drop-down boxes, try refreshing the page.

Our Tip: Any database name or database username you create will both be automatically prefixed with your username. A database that you call "gbook" will be named "username_gbook" (where username is your account username).