WordPress · Let.com knowledge base

How to create a MySQL Database in cPanel

Updated 2024-08-222 min read

Hosting reference guide. Screenshots may show earlier interfaces. Account access is coming soon. Confirm current menus, server details and nameservers for your account.

In this article we will be showing you how to create a MySQL database.  There are two options to create a database: MySQL Databases and MySQL Database Wizard.  The Wizard option is a much more simple option, and is highly recommended for anyone creating a database. We will be going through both options below.   

 

MySQL® Database Wizard

 

  • Enter a name for the database and then click Next Step, this will create the database.

Guide illustration for How to create a MySQL Database in cPanel

 

  • Now we will need to create a username for that database with a password.

Guide illustration for How to create a MySQL Database in cPanel

 

  • The Final step is to select what type of privileges to give to the MySQL user. In most cases  you will just select ALL PRIVILEGES.

Guide illustration for How to create a MySQL Database in cPanel

 

MySQL® Databases

 

In this option you have more freedom of control over your database. You are able to delete or rename a database, delete a user from the database, or add multiple users to a single database. You are also able to change a MySQL user password, as well rename  or delete MySQL users. One last key feature is also the option to repair a database and fix any errors that show up.

 

  • First enter the name you want for the database and click Create Database

Guide illustration for How to create a MySQL Database in cPanel

 

  • Then scroll down to Add New User to create a new user for that database with a password.

Guide illustration for How to create a MySQL Database in cPanel

 

  • Now we need to add that user to the database and assign the privileges to the user. 

Guide illustration for How to create a MySQL Database in cPanel

   

Did this point you in the right direction?

Talk to the Let.com team

Frequently asked questions

What you need to know.

Get support

Which database creation method is simplest for a new database?

The guide recommends MySQL Database Wizard, which walks through naming a database, creating a user and assigning that user’s privileges.

Is creating a database user enough to grant access?

No. The user must also be added to the database and assigned the intended privileges. Both workflows in the guide include that association.

What extra controls are in MySQL Databases?

The broader interface includes database and user management, password changes, adding users and database repair controls.

Let.com

Coming soon.

Account sign-up, log-in and checkout are not available yet. You can explore our products and compare plans while we get everything ready.

Compare plans