Currently set to No Index
Currently set to No Follow

Get the Official WPSaviour App Now!

BlogWordPress Hosting

How to Create Database For WordPress Manually on a cPanel Hosting Like Bluehost

Whenever you are creating a WordPress blog or a database centric platform, creating database is one of the things that you need to do. Thanks to many auto-installer scripts, which does the job for you, but there are times when you need to manually create the database. The step to create database is quite simple on many web hosting which offers standard cPanel.

Yesterday, I was migrating a WordPress blog from GoDaddy to Bluehost, and to complete the process I had to create the database manually. For newbies, creating database might not be that easy, and this tutorial will be helpful to learn the complete process.

Do remember, Bluehost offers standard cPanel, and this tutorial applies to all the cPanel hosting companies for example (Hostgator, SiteGround, Hostmonster) which offer cPanel hosting.

Creating WordPress Database manually on Bluehost or cPanel hosting

Do remember, this step is required only in need, as most of the auto-installer script create and associate database automatically. For example, when you will install WordPress on Bluehost using this tutorial, it will automatically create a database for you.

On some hosting, when you have to install WordPress manually, creating database is part of the process, and you need to follow this tutorial to create one for your new blog.

Here is step by step process:

  • Login to your Bluehost Account
  • Click on go to cPanel, which is standard cPanel.
  • Under databases, click on MySQL databases

Now under new database, give a name to database you want to create. You can use anything like “WP” “WordPress” . In this example, I’m using WordPress

create database bluehost

Once we have created the database, we need to create a username/password and associate it with created database.

Here is how to do it:

Click on the go back after creating the database. Now, on the same page, MySQL users, click and add a new user and password. You can use any username you want, and use the password generator to generate the password. You should also note down the MySQL username and password on a note file for future reference.

create MySQL usersSo far we have manually created a database, MySQL user, and password. And now all we need to do is, associate the database with created user. On the same page, you will see an option to “Add user to database.”

associating user to database

Click on Add, on the next page, you need to give All privileges to MySQL user for accessing the database. Simply check all on the next page, and click on Make changes.

MySQL privilege

This is it; now your newly created database is ready to be used for WordPress or any other self-hosted platform you are using. As I mentioned above, the process of creating a manual database will be the same on all cPanel hosting. If you are stuck or have any questions regarding the same, feel free to ask via comments.

Download The WPSaviour App Now

Related posts
Beginner’s GuideBlogTips

Top 5 free payment gateway plugins for WordPress in India (2020)

Beginner’s GuideBlogTips

Best WooCommerce International Payment Gateways for WordPress in 2020

Best WordPress PluginsBlog

WordPress 5.4 Will Add Lazy-Loading to All Images

Beginner’s GuideBlog

How to Add a Preloader Animation to WordPress (Step by Step)

Sign up for our Newsletter and
stay informed

Leave a Reply

Your email address will not be published.