Database

Next we come to where you enter the connection information for your MySQL database.

This tends to be one of the more confusing steps, but it really doesn't need to be.  All of the information for this page is somewhere within your hosting control panel.

Database Server
Odds are very good that you can leave this at the default 'localhost' and be fine.  However some large hosts, notably GoDaddy and StartLogic, host their web sites and database separately in which case you'll be given another host name to put in here.

Username & Password
The username and password for your database are likely not the same as the login you use to get into your hosting control panel. When you setup your database you likely entered a username and password.  Sometimes the username and database name are the same.  And some hosts will assign the username and password for you.

If you are on a host that uses cPanel your database username includes your login as well, so if your cPanel login is bob and you make a database called buddy the username would be bob_buddy.

Database Name
This is the name you gave your database when you created it.

Like the username, hosts using cPanel will append your login to the front of the database name as well.

Prefix
ProofBuddy uses 3 dozen database fields.  The prefix allows you to use an existing database without conflicting with any existing tables.  Your best bet is to just keep this at pb unless you have a good reason for doing otherwise.

A special note for cPanel servers
If your host uses cPanel, and most hosts do, you'll need to make sure your cPanel username is in front of your database name and username. For example, if your cPanel login is bob and you create a database named buddy, you would type bob_buddy as the database name. Same idea with the database username.

6 comments on this post

  1. Hi there,

    I've installed proofbuddy and am busy with the setup, but when I come to the database page after completing the information for the database it does nothing - I don't get an error message nor do I get taken to the companie tab.

    Any advice would be appreciated

    • What browser are you using? Mac or PC? Do you see any Javascript errors? Internet Explorer typically puts them down on the bottom right of the window.

  2. Hi

    I am hosted with godaddy and i am setting up proofbuddy, but i have come to this database page in the installation and i have entered all my information
    Database Server: _________.db.(numbers).hostedresourses.com {which is godaddys server for a MySL}
    i entered my user name and pw and the database name. and left the prefix as pb

    but i am having an error of "cannot connect to database, check server, user name and password"

    i am working on a Windows 7 PC. and running internet off Google Chrome and havent had any issues till this point. am i missing something?

    Any help would be great.
    Thanks

  3. Hello,

    My client would like to buy proofbuddy.
    However I am trying to test the script does not connect to the database. I usually connect via phpmyadmin.

    http://www.geagostifotografia.com.br/provafoto/phpinfo.php

    mysql01-farm25.uni5.net

    Unable to connect to the database server. Please double check the server name, username, and password.

    • It should be the same login info as what you use for phpMyAdmin. Most common issues are either a & or ? in the password or incorrect server name. Some hosts, usually the big ones like GoDaddy, will use separate MySQL servers instead of localhost.

Leave a Reply