How to Create MYSQL Database with Cpanel: Creating your very own Database might seem like an overwhelming task, but to be honest, it is effortless to do so by following a simple procedure. If you want to create a “MySQL Database” but cannot do it due to complexity, you are at the right place.
In this Cpanel Tutorial training, we will guide you in how you can create your MYSQL Database through “Cpanel” and also provide you with some extra knowledge.
You will need Database due to many reasons like; • Secure install of WordPress. • Purchased software.
Where to Find the SQL Database?
- First of all, you need to open the "Cpanel"
- Then Scroll down till you find the "Database Panel"
- After that, you need to click on the “MySQL Database".
Attach the Screenshots here."
Creating a Database with Cpanel:
- You will see the “Create a new Database box."
- Inside this Box, you need to “Name” the Database whatever you like
- And here you have it, your own Database.
- This is the name of your Database written in Commas; you need to Copy the name of Database to your Notepad.
"Attach the Screenshots here."
Securing the Information through MySQL Users:
- Then you need to go towards the Box of “MySQL users” and enter the “Username.”
- There is a “Password tab," followed by the Rewrite Password and the Strength of Password. • It would be best if you wrote your Password there and then rewrite the same below.
- Afterward creating the users, a user is generated, which you need to copy and paste into the same Notepad you used to store the Database name.
- Note: It is advised that you also save the Password in Notepad.
"Attach the Screenshots here."
Adding the User to a Database: • By default, the user and the Database are selected, but if you want to confirm them, click on the arrow and select the desired Database you just created.
- Click on the “Add button” to add the user to the Database.
- Afterward, you will be forwarded to the MySQL Account Maintenance.
"Attach the Screenshots here."
Manage User Privileges:
- Here you will have different tabs with their checks, which allow you to add the privileges or remove them after making the changes.
- Note: You will have to check the “All Privileges” and then click the Make Changes to add the Privileges
- Here you have it, a complete Database by your self. Then you can use the Database with WordPress afterward. "Attach the Screenshots here."
Results: Creating Database isn’t that hard with CPanel, follow the steps provided by us to know exactly what to do for acquiring a complete MySQL Database. It is important to note that using the steps to create the Database Name, Username, and Password. You need to save it in a separate My Notepad File to know what was written in it for further settings.
