How To Set Up a Database using the MySQL DB Wizard

Reading Time: 2 minutes

This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen. Let’s learn how to set up a database using the MySQL Database Wizard. Click the “MySQL Database Wizard” icon.

cpanel-pl-mysql-1-wizard-02

  1. Enter a name for the new database, then click “Next Step”.cpanel-pl-mysql-1-wizard-03
  2. 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
  3. Click the “All Privileges” check box, then click “Next Step”.cpanel-pl-mysql-1-wizard-05
  4. 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
  5. Now click the MySQL Databases icon on the main page.cpanel-pl-mysql-1-wizard-07
  6. Here you can see the new database you just setup.cpanel-pl-mysql-1-wizard-08

 

Avatar for dpepper

About the Author: dpepper

Latest Articles

How to Install Zen Cart on CentOS 7

Read Article

How to Make OpenStack Work for You

Read Article

Five Steps to Create a Robots.txt File for Your Website

Read Article

Premium Business Email Pricing FAQ

Read Article

Microsoft Exchange Server Security Update

Read Article