Wordpress Today Agency Logo

How to Set up a New MySQL Database and User in cPanel

MySQL Logo

cPanel makes some stuff easier. One of the things you can do in cPanel that will help you save a lot of time is create a database and a MySQL user. In this tutorial we will show you how you can configure a fresh MySQL database and a cPanel user using the MySQL Database Wizard.

First thing first, you have to log in to cPanel.

In the “Database” section, click on the “MySQL Database Wizard” link or icon. 

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

Create the MySQL Database

Step 1: Create a database and enter its name in the “New Database” field. A prefix will be pre-populated. The format may vary depending on your host, but a prefix is imperative. The database name must have a prefix and an underscore.

After you have done these things, click on the “Next Step” button.

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

Create the MySQL Database User

Step 2: Creates database users. Enter the name of the user or users in the “Username” field. This name must also include a prefix. The name includes the prefix and the underscore. Enter a password. The password must be strong enough for the system to accept it.

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

After you’re done, click on the “Create User” button.

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

Add the User to the MySQL Database and Grant User Permissions

If you want, you can select custom permissions for each new user. However, for most applications you will want to give the user all permissions. To do this, simply click on the “ALL PRIVILEGES” box.

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

Scroll down and press the “Next Step” button. 

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

After you set the permissions, you will see a success message. The success page also includes useful links such as “add another database” or “add another user for your MySQL database.”

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

Everything you need to connect an application to the database is now set.

Managing MySQL Databases and Users

To manage your database and users, you need to go back to the “Databases” cPanel section and click on “MySQL Databases”.

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

Scroll down to the “Current Databases” section.

From the “Privileged Users” column you will be able to change the permissions by clicking on the username. If you want to revoke all privileges, click on Trash Icon. To rename the database you have to go to the “Actions” column and click on the “Rename” icon, and to delete it you have to click on the “Delete” icon.

How to Set up a New MySQL Database and User in cPanel - WordPress Today Agency

And that’s it! As you can see, it is very simple to set up a database in cPanel.

Related Posts

WordPress Today Agency Elementor Logo

How to Use Elementor: A Step-by-Step Tutorial

Hey there! If you’re looking for a tutorial on how to use Elementor, you’ve come to the right place. In this post, I’m going to walk you through the basics of using Elementor, step by step. Whether you’re a new user or a seasoned pro, this tutorial will give you all the info you need to get started. So let’s get started!

Read More »

FileZilla Tutorial

In this tutorial, we will explain to you how to use FileZilla to upload your website. With SiteGround you get unlimited FTP access and unlimited

Read More »
WordPress Logo

How to Install WordPress

This tutorial covers the following topics: Step 1. Download the WordPress installation package Step 2. Upload the WordPress Files to Your Server Step 3. Create

Read More »
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency

 
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency

 
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency

 
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency

 
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency

 
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency

 
Wordpress Today Agency Logo

Let’s talk about your project and how it aligns with your business strategy.
You can also email us at contact@wordpresstoday.agency