How To Create A MySQL Database In cPanel

MySQL is a powerful database engine that allows you to store and manage data in an organised and performant fashion. Many web applications you may use on your hosting service utilise MySQL to store data, such as WordPress.

Creating a database for your software is simple and in this guide we will show you how its done!

We recommend using cPanel’s MySQL Database Wizard. This streamlines the process in to a handful of steps to get you up and running quickly.

Step 1. Find The Wizard! #

Thankfully you won’t be needing to go to Hogwarts for this one. Locate the Databases section or use the large search bar at the top of the screen to search for “MySQL”. Then, click on to the MySQL Database Wizard option shown below:

Step 2. Name Your Database! #

In this step you should provide a name that best describes the use for the database. For example, “wordpress” or “blog”. When you are ready, click “Nest Step” to begin the process of creating your database user!

Step 3. Create Your User! #

As shared website hosting relies on sharing one server between multiple websites, we need to ensure that the only applications that can access your database are ones that you have authorised. For this MySQL has a user system where you create a username, password and select which permissions the user has to the database.

In this step you get to name your user anything you wish, but we recommend keeping it easily recognisable (e.g “wordpress” or “wp”) but we suggest keeping it different from the database name.

Once done, click Create User to move on to the next step!

Step 4. Permissions! #

This is how you manage what your new user can and can’t do on the database created earlier. For most use cases when using the MySQL Database Wizard you’ll allow all permissions in the list. cPanel makes this easy by having an “All Privileges” option at the top.

Tick this box to allow all privileges (permissions) to this user and click Next Step to move on to the final step

If you are an advanced user, feel free to customise the permissions to your liking.

Step 5. We’re Done! #

That’s it! Now, remember to keep the MySQL username and password safe and only use it for your intended purpose. If you need any help at all, get in touch with our support team and we will be more than happy to help!

Are you looking for carbon negative hosting to make sure your website leaves a positive impact on the world? Take a look at our green hosting information or check our our NVMe cPanel Hosting plans and leave a real positive impact on the world.