How do I create a MySQL database?

cPanel will guide you through the process of setting up a MySQL database, along with the requisite accounts and privileges, step by step.

Set up a database using the MySQL Database Wizard with these steps:

1) Login to your Account Manager at https://www.yourdomain.con/cpanel
2) In the "cPanel" side menu, click on "Search for Mysql"
3) Under the "Databases" category, click on "MySQL Database Wizard"
4) Choose your database name and click on the "Create Database" button

  1. In the New Database field, enter a name for the database.
  2. Click Next Step.
  3. In the Username field, enter a name for the user allowed to manage the database.
  4. In the Password field, type the user’s password.
  5. Retype the password in the Password (Again) field.
  6. Click Create User.
  7. Select the privileges you wish to grant the user, or select ALL PRIVILEGES.
  8. Click Next Step.

Next, cPanel will display a message stating that the database and user account were successfully set up. From here, you may select 1 of 3 options:

  • Add another database — Returns to the start of the MySQL Database Wizard.
  • Add another user using the MySQL Databases Area — Opens the MySQL® Databases page, wherein you may create additional user accounts and assign them to a database.
  • Return to Home — Opens the cPanel home screen.

note Note: When you add a user and database using the MySQL Database Wizard, the user is automatically given access to the database; there is no need to use the Add User to Database feature.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to install WordPress through Softaculous in cPanel

WordPress is one of the most well-known CMS for blogging. One can install it manually through...

How to delete Trash in WordPress Automatically? – WordPress Tips & Tricks

We receive a number of requests from customers using our WordPress Hosting service for ways to...

Guidelines To Resolve The .htaccess Issues in WordPress

WordPress is one of the most widely used open source content management systems that is designed...

Say NO to Trespassers, DDoS Attackers and Hijackers from your WordPress Site by Restricting Access to wp-admin

Late last month the Internet faced one of the biggest DDoS attacks in the history. With not even...

The future of computing is in Meltdown

The Meltdown It’s recently been revealed that a design flaw in basically all of the world’s...

Powered by WHMCompleteSolution