Database details are required to be provided during manual installation of your WordPress site so that WordPress can connect with the database to save your content. It is also recommended to create your database with complex username and password for security reasons. Here we discuss the step by step process of how to create WordPress database in Bluehost hosting account.
Step1 – Accessing MySQL Databases
Login to your Bluehost hosting account and go to cPanel. Click on “MySQL Databases” icon available under “Database Tools” section.
Step2 – Creating New Database
Navigate to “Create New Database” section under “Databases” tab. Enter a database name and click on “Create Database” button.
Step3 – Creating New User
Next step is to create a new user under “Add New User” section. Enter a name, password and click on “Create User” button.
Step4 – Connecting Username and Database
Now you have an username and a database, connect them under “Add User to Database” section. Select the username and database from the drop-down and click on “Add” button.
You will be prompted to provide necessary privileges to the user to modify the database. Select “All Privileges” to provide a complete access of database to this user.
Connecting Database to WordPress
Now that your database is ready and the final step is to connect it to your WordPress site. During installation process WordPress will prompt you to enter database details where you need to enter the database name, username and password as created in the above steps. The other way is to modify the wp-config.php file and add the database details. Once connected successfully you will be able to access your WordPress admin dashboard.
Hostname for your database is always “localhost”, if this is not working then use the Bluehost server name boxxxxx.bluehost.com as a hostname. You can see this server name under “Notice” section of “MySQL Database” screen.