Hey every body! Today we’re going to look at how to make a MySQL database in cPanel. This is really easy to do and should only take a couple of minutes.
Once you have logged into your cPanel account you are going to scroll down to the “databases” box. There will be a few icons to choose from, but to create a database we want to click on “MySQL Databases”.
You’re then taken to the database and user creation page. We’ll start by naming the database.
I used the database name “akaser_wordpress”.
Next we need to create a user for the database. To do that, you scroll down to the user creation section and enter a username and a password.
I used “wordpressuser” as my username and “temppass123” as my password. (please use more secure passwords!)
click create, and then get back to the database and user creation page. Now we’re going to scroll down to the bottom and we’re going to add the user to the database that we just created.
You simply select what database and username you want to connect, and click “add”.
A page with “permissions” will come up and generally selecting “all” at the top is the way to go. You may have reasons in the future to not use all and that’s just fine.
save the changes and that’s it! You’ve now created a MySQL database and you’re ready to start developing on it 🙂