Backing up your GoDaddy cPanel database with CodeGuard is easy! Simply follow along with the tutorial below.
Step 1: Find Database Credentials
You will need the following pieces of information to connect your database to CodeGuard:
- Database Hostname or IP
- Database Name
- MySQL Username and Password
- MySQL Port Number
If you have this information already, you can skip ahead to step 2.
Hostname: Your hostname will most likely be your domain name or the IP address of your server. After logging into your account the IP address of your website should appear in the left sidebar. This will be the IP address to use.
Database Name: During the database addition process you will be able to select the database you are trying to back up from a list of available databases. If you have more than one in your account you should determine ahead of time which database you would like to back up.
Username and Password: You need a MySQL username and password with permission to access the database you would like to back up. To create a new database user, click on the 'MySQL Databases' icon in your cPanel dashboard.
Scroll down on the following page to the section titled "MySQL Users." Fill out the form to create a new user like so:
Once you have created a new user, fill out the form directly below titled "Add User To Database" and assign your new user to the database you would like to back up. Note: If your website has multiple databases, you should assign that user to all the databases you want to back up.
On the following page, you will be asked to manage user privileges for your new user. Select 'All Privileges' and save.
Write down all of the information that we just found and keep it close. We will be using it shortly!
Step 2: Whitelist CodeGuard IP Addresses
In order to connect your database to CodeGuard, you must allow remote MySQL access of your database. To do this click on the "Remote MySQL icon in your main cPanel dashboard.
Next, enter the following IP addresses one at a time into the input field on the following page, and select "Add Host."
Step 3: Add Database
Log into your CodeGuard account, and then follow the steps in this article to add your database to CodeGuard.