cPanel

One of the first steps you'll need to take before installing ProofBuddy is to create a MySQL database.  For this tutorial we're going to use cPanel because it seems to be the most popular web hosting software.

cPanel does allow the host to use different themes so it is possible that your screens may look slightly different than those shown here.

MySQL Control Panel
Log into your cPanel control panel and click on the MySQL icon.  It looks like the following.

Creating a new database
You will be taken to the MySQL Account Maintenance page.  Look for the 'New Database' section.  It looks like this.

Give your database a name.  For this tutorial we're going to call it buddy since we're using it for ProofBuddy.  Click on Create Database and you should be taken to the following screen.

Once you get to this point you've successfully created your database.

Click on Go Back to be taken back to the MySQL Account Management page.

Adding a User
Your next step is to add a user that can access your database.  Just below the New Database box we used before is a pair of boxes with Username and Password next ot them. Enter buddy for the username and whatever password you want - I'm going to use 'password', a really, really bad idea for a password but good as an example.  Then click on Create User to be taken to the following page.

 

Note that you can use any username that you want as well, although we'd suggest that you make it something that relates to ProofBuddy, proofing, clients, etc to help you remember.

Now you have a username and password that you can use for your database.  But you also need to give your new user permission to access the database you created.  Click on Go Back.

Giving Permissions
Just below the boxes where you added your user you will see a section titled Add Users to your Database.

One thing to notice.  The database and user you created both have a prefix.  This prefix should be the same as your cPanel login name.  For this example it's buddy, but it could be what you chose when you created your account or could be a string that your host assigned to you when your account was setup.  This is important because when you enter your database name and username during the ProofBuddy installation you will need to include the prefix as well.

Select yoru new user in the first drop down and the new database in the second.  Leave the checkbox next to aLL checked and the rest unchecked.  Then click Add User To Database and you should be taken to the following screen.

And we're done
Congratulations.  If you've gone through the steps above and havenn't come across any errors you have successfully created a MySQL database for ProofBuddy to use.

Leave a Reply