How To Set up a Database using the MySQL Database Wizard in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to setup a database using the MySQL Database Wizard. Click the "MySQL Database Wizard" icon.

    cpanel-pl-mysql-1-wizard-02

  3. Enter a name for the new database, then click "Next Step".

    cpanel-pl-mysql-1-wizard-03

  4. Now we have to create a user for this database. Enter a username and create a password, then click "Create User".

    cpanel-pl-mysql-1-wizard-04

  5. Click the "All Privileges" check box, then click "Next Step".

    cpanel-pl-mysql-1-wizard-05

  6. That’s it! My MySQL database has been created, and the new user added to the database. The database name, username and password will all be needed for scripts that need to connect to the database.

    cpanel-pl-mysql-1-wizard-06

  7. Now click the MySQL Databases icon on the main page.

    cpanel-pl-mysql-1-wizard-07

  8. Here you can see the new database you just setup.

    cpanel-pl-mysql-1-wizard-08

 

Be Sociable, Share!

    Published by

    Here's 75 % off, Launch a New VPS Today. Find out why 30,000 customers have chosen our Best-in-Class Performance & 24x7 Heroic Support