Bluehost Web Hosting Help

WordPress Install Without Automatic Database Creation

Summary

This article explains how to install WordPress when Mojo is unable to create the database automatically.

Create a Database and User
Install Through Marketplace with Database Creation Turned Off

Create a Database and User

To install WordPress when automatic database creation is not available you need to manually create a database, user, and assign the user to the database. For more information on the process of creating a database and user see How to Create and Delete MySQL Databases and Users. These are the basic steps.

Creating A New Database

Log in to your Bluehost cPanel account.
Go to the cPanel in your account.
Under the databases section click on MySQL Databases.
In the new database field enter a name for the database.
Note: The database name can be anything you like but I recommend the name be something related to your site. Vague names like "database" or "wp1" may make it harder to tell what the database is for. Especially if you have multiple databases.
Click Create Database.
Click Go Back.

Creating A New User

Locate the MySQL Users section.
Under Add New User enter a username and password.
Click Create User.

Assign the Database User

Under Add User to Database, select the new user from the user drop-down menu.
Select the new Database.
Click Add.
Select All Privileges.
Click Make Changes.

Install Through Marketplace with Database Creation Turned Off

From this point the installation of WordPress is normal with one exception. When you get to the installation options page you must click on Advanced options and disable automatic database creation. Then manually enter your database information.

Go to Marketplace and start the installation.
Check the "Show Advanced Options" box.
Uncheck the "Automatically create a new database for this installation" box.
Enter the new database information.
- The Database Name is the name of the new database you created.
  Note: Don't forget to include the prefix on the database name which is your username followed by a "_". The Database name should look something like examplec_exampledb.
- The Database User is the name of the new user you created and assigned to the database with all privileges.
  Note: Don't forget to include the prefix on the user name which is your username followed by a "_". The Database user should look something like examplec_user.
- The Database Password is the password you created for your database user.
- The Database Host should be left at its default value of localhost.
- The Database Prefix is a random set of characters followed by an "_" you do not need to change this field.
Agree to the terms and click install now.