Whenever you create a WordPress blog or a database-centric platform, creating a database is one of the things you need to do. Thanks to many auto-installer scripts, they can do this for you, but sometimes you need to create a database manually. On many web hosts that offer a standard cPanel, the steps to create a database are very simple.
Yesterday, I migrated a WordPress blog from GoDaddy to Bluehost, and to complete this process, I had to create the database manually. Creating a database may not be that easy for a newbie, and this tutorial will help you understand the whole process.
Remember, Bluehost offers standard cPanel and this tutorial is applicable to all cPanel hosting companies that offer cPanel hosting like ( Hostgator , SiteGround ).
Manually create a WordPress database on Bluehost or cPanel hosting
Keep in mind that this step is only required if needed, as most auto-installer scripts will automatically create and associate the database. For example, when you install WordPress on Bluehost using the tutorial , it automatically creates the database for you.
On some hosting, when you have to install WordPress manually, creating a database is part of the process, you need to follow this tutorial to create a database for your new blog.
Here is the step-by-step process:
- Log in to your Bluehost account
- Click Go to cPanel, which is the standard cPanel.
- Under Databases, click MySQL Database
Now under New Database, give a name to the database you are going to create. You can use any name like "WP" "WordPress". In this example, I am using WordPress
Once we have created the database, we need to create a username/password and associate it with the created database.
The specific operations are as follows:
Click Return after the database is created. Now, on the same page, click MySQL Users, and add a new user and password. You can use any username you want, and generate a password using the Password Generator. You should also write down the MySQL username and password in your notes file for future reference.
So far, we have manually created the database, MySQL user, and password. Now all we need to do is associate the database with the created user. On the same page, you will see an option to "Add User to Database".
Click Add and on the next page you need to grant the MySQL user all permissions to access the database. Just check everything on the next page and click Make Changes.
That’s it; now your newly created database is ready to be used with WordPress or any other self-hosting platform you are using. As I mentioned above, the process of creating a manual database is the same on all cPanel hosting. If you get stuck or have any questions about this, feel free to ask via comments.
Further reading:
- How to use a free SSL certificate with Bluehost
- Cheap WordPress Hosting
- How to Update to PHP 7+ on Bluehost Web Hosting Using cPanel
Disclosure: Some of the links in this article contain affiliate links, which means we may earn a commission if you click through to visit us, at no extra cost to you. See how SidelinePlay is funded, why it’s important, and how you can support us.
Was this helpful?