How to manually add your Bluehost database to CodeGuard

Backing up your MySQL database is now easy, reliable, and secure with CodeGuard!

Find Your Database Information

You will need to find the following information:

  1. Database Hostname or IP
  2. Database Name
  3. MySQL Username and Password
  4. MySQL Port Number

Step 1: Log into your Bluehost hosting account

login.png

Click the "Advanced" tab on the left side of the screen

advanced.png

Step 2: Locate your hostname

The hostname will be the URL of your control panel as highlighted in the screenshot below

address_bar.png

Step 3: Create a new MySQL user and assign it to your database

In the "Databases" section, click "MySQL Databases"

mysql_databases.png

Scroll down to the "Add New User" section. Enter the username you'd like and a strong password and click "Create User".

create_user.png

The MySQL user that you will use to add your database is going to be the the username you created plus the prefix. In the example above, the MySQL username would be bluehqf3_cguser.

After creating your user, click "Go Back"

go_back.png

Next, you will need to add your user to the database. If you are adding multiple databases, you will need to do these next steps for all databases being added.

Scroll down to the section titled "Add User To Database". Select your newly created user and the database that you will be adding from the dropdown menu and click "Add".

add_user_to_database.png

The next step is to grant all privileges to your MySQL user. This will allow us to perform the steps needed to successfully back up and restore your databases.

grant_privileges.png

When you see the success notice, click "Go Back"

go_back2.png

You will now see that your MySQL user has been added successfully to your database. Again, if you have more than one database to add, you will need to add your user to each of them.

user_added.png

Step 4: Log into your CodeGuard Account

Click the Account icon and click "Products" in the dropdown menu.

products.png

Next to your CodeGuard plan name, click "Log in".

login2.png

Step 5: Add your database to CodeGuard

Scroll down to the "My Sites" section of your CodeGuard dashboard and click the "Actions" dropdown next to your website and select "Add Database".

actions.png

Enter your hostname that you got from the Bluehost Control Panel URL then click "Test Connection".

test_connection.png

Next, we will check to make sure there are no firewall rules blocking our connections from some of our IP addresses. When all checks pass, click "Next Step".

check_firewalls.png

You can safely skip this next step. As a Bluehost customer, our IP addresses are already whitelisted. Go ahead and click "Next Step".

whitelist_ips.png

Next, you'll enter your new MySQL user's username and password and click "Next Step".

db_credentials.png

Here, you'll see a list of all of the databases that you added your MySQL user to. Select the databases that you'd like to back up. If you want all of them, click "Select All". Once they are selected, click "Add Databases".

select_dbs.png

Your database backups have begun! For the initial backup, you will be shown a progress tracker. It will take you step-by-step through the database's initial backup. There is no need to sit and watch this if you don't want to. You will be notified by email when the initial backup is complete.

progress_tracker.png

When the backup is complete, you will see your first backup show in your dashboard.

complete.png

Congratulations! You have successfully added your databases to CodeGuard!

If you have any questions about this process, or if you run into any trouble, please contact the fantastic Bluehost support team by any of the following methods:

  1. Call Bluehost at 1.888.401.4678. System administrators and knowledgeable professionals are available 24×7 to answer your questions and assist you.
  2. Live chat with Bluehost – https://helpchat.bluehost.com/ – and their staff can assist you.


Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request