How to Set Up a Database Using the MySQL Database Wizard

Posted on by Ronald Caldwell | Updated:
Reading Time: 3 minutes

Creating a database in cPanel is helpful for web developers managing large amounts of data for their websites and applications. The process is simple and essential to the development of database-intensive projects.

Requirements

  • A server running cPanel.
  • cPanel login credentials with access to database permissions.

How to Set Up a Database Using the MySQL Database Wizard

1. Type https://youripaddress:2083 into your browser to access the cPanel login screen. Replace youripaddress with your actual IP address.  Enter your credentials and press Log in.

2. Click MySQL Database Wizard.

3. Enter a name for the new database and click Next Step.

4. Create a user for this database by entering a username and creating a password. Click Create User.

5. Click the All Privileges check box or select individual privileges based on your preferences for the user. Click Next Step to continue.

6. The MySQL database is created, and the new user is added. You need the database name, username, and password for connecting scripts to the database. Click Return Home to return to the cPanel home page.

7. To view your databases and make other changes, click MySQL Databases on the home page.

Here you can view and modify the database and users.

Wrapping Up

Creating a database using the MySQL Database Wizard is quick and easy. And with Liquid Web’s 24/7/365 support, customers get the help they need without having to worry about these processes.

Are you looking for the right hosting solution for your next project? Contact our support team to discuss our managed hosting options and find the right fit.

Avatar for Ronald Caldwell

About the Author: Ronald Caldwell

Ron is a Technical Writer at Liquid Web working with the Marketing team. He has 9+ years of experience in Technology. He obtained an Associate of Science in Computer Science from Prairie State College in 2015. He is happily married to his high school sweetheart and lives in Michigan with her and their children.

Latest Articles

How to Set Up Hotlink Protection in cPanel

Read Article

How to Set Up Hotlink Protection in cPanel

Read Article

What is the Difference Between NGINX and Apache?

Read Article

Accessing Man Pages on Ubuntu 16.04 LTS

Read Article

What is VMware Fusion?

Read Article