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.
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.
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.
After you’re done, click on the “Create User” button.
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.
Scroll down and press the “Next Step” button.
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.”
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”.
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.
And that’s it! As you can see, it is very simple to set up a database in cPanel.