How to create a MySQL database in GoDaddy
We have several clients using GoDaddy as their host, and it appears that GoDaddy has improved their hosting since ProofBuddy first came out and ProofBuddy can now successfully be run on GoDaddy Linux accounts.
One note... This tutorial was written in February 2008 and the steps below worked at that point. GoDaddy has a knack of changing things around so what you see on screen may be slightly different than the screen shots. If you have any questions, please use the comment form below and I'll do my best to help you get it setup.
Step 1 - Login to your account
First you need to go to GoDaddy and login to your account. Once you've logged in, move your mouse of the Hosting & Servers menu item and you will see a dropdown like the following image. Click on My Hosting Account.
Step 2 - The control panel
You will be taken to a screen that looks like the following.
Next to the domain you want to edit, click on the Open link to go to the control panel.
Once in the control panel click on the Databases heading and then the MySQL icon.
Step 4 - Creating the database
If you already have a database you will see it listed here. If not, it will be blank. Click on the Create Database button.
After clicking on the Create Database button you will be taken to the following screen.
Give your database a name. You will also need to create a username and password to access this database which you will need to know for the ProofBuddy setup process.
You have the option of creating either a version 4.1 or version 5.0 MySQL database. ProofBuddy will run with either version but has been tested more heavily with version 4.1.
There is also an indicator on how strong your password is. For GoDaddy to accept the password it must start with a letter, contain at least one upper case letter, and contain at least 1 number.
Step 5 - Getting the database information
There are a few pieces of information you will need to get ProofBuddy up and running with your newly created MySQL database. After you have created your new database you will be taken back to the database list.
Under the Action column you will see two icons. Click on the icon that looks like a pencil next to the database that you created for ProofBuddy. This will take you to a page where you can view the settings for this database.
You will need the host name, database name, user name, and the password that you entered for this user name in the previous step.