You can’t have a blog or a website without a database. In fact, it is one of the first things to do. It is a fairly simple process that you can achieve with one of many auto-installer scripts. They will do quickly and decently enough, and there is nothing more to it than that if you use that method.
However, if you want to create it manually, or worse, if you come to a situation where you have to do it manually, you should know how it works. It is a simple process if you have a standard cPanel, and in this text, we will guide you through it.
Note: Want to see a great Bluehost Review?
When do you have to create a database manually?
Some users prefer to create their databases themselves, without employing auto-installers. Others who still use them sometimes want to change their host. When you decide to migrate from one hosting service to another, you will have to create a database on the new one by yourself.
If you are not tech savvy, or you are new to the entire world of website creation, this is the guide for you. We will explain the entire process and walk you through it so that there is nothing for you to worry about.
Since Bluehost is one of the most famous hosts that offer cPanel, we have decided to use it as an example. However, this tutorial can help anyone who uses cPanel, no matter which hosting service do they prefer. Whether you are on Bluehost, Hostmonster, SiteGround, or HostGator, you can use these same instructions to create your own database.
How to create WordPress database on Bluehost or other cPanel hosting manually?
Once again, this tutorial is only for rare cases when you actually need to do it manually. Thanks to auto-installer scripts, the entire process can be finished automatically in an instant.
In fact, some hostings actually allow you to do it as a part of a manual installation of WordPress itself. As for the process, here are the steps that you have to take:
- Login into your account on Bluehost
- Go to the cPanel, which should be a standard version
- Go to the databases section, and then choose MySQL databases
You must now give your database a name that you want to use. It can have pretty much any name, and for our example, we will call it WordPress.
After making it, you have to create a new username and password and associate them with your new database.
You can do it like this:
- After creating the database, click on the ‘go back’
- On the previous page, add a new username and password
- You can use a password generator, just to stay safe. As for the username, use whatever you want
- Write these credentials down, for when you need them in the future
What we have covered for now includes the manual creation of a database, MySQL username, as well as MySQL password.
Now comes the part when you associate the database with MySQL user. The option is on that same page, and it is named ‘Add user to database’.
Hit ‘Add’, and when you get to the next page, allow all privileges for accessing database to MySQL user. You can do that by checking all the boxes on the said page. When you are done, click on the ‘Make changes’ button.
And that is it. You now have an entirely new, manually created database that you can use for WordPress or some other platform.
If you have followed the tutorial closely, then you should not have any problems with doing this. The process is extremely quick, as you can see, and you are done in just a bit more than a few clicks.
Once again, you will probably only need this guide in rare occasions when there is no auto-installer.
Ali is a freelance journalist with 5 years of experience in web journalism and marketing. He contributes to various online publications like Best10VPN. With a master degree, now he combines his passions for writing about internet security and technology. When he is not working, he loves traveling and playing games.