Tutorial: GoDaddy Hosting, Php w/ MySQL
It seems that each web host likes to have their customers create databases & connect to them a little differently. These are reasonably simple things to accomplish if your host’s process is well-documented. Unfortunately, this is not always the case. For hosting with GoDaddy (godaddy.com), follow these steps to set up a MySQL database. The last screenshot & paragraphs contain connection information.
1. Login to the account control panel on the web host.
2. In the Databases category, click on the MySQL icon.
3. Click on the CREATE NEW DATABASE link in the following screen.
4. The screen should refresh to show that the database has been created. When it does, the User Name will appear.
Your database has now been created. Now that it exists, connecting to it is a snap.
5. Click the OPEN MANAGER button to the right of the user name. The following dialogue opens, showing an example connection via php & mysql code.
If you wish to write your own sql queries & such, use this as your guide. If you use Dreamweaver® & phpMyAdmin for connections & queries, get the username & dbname from here, combine these with your password & accomplish the connection in Dreamweaver®.
Note: should you be developing on another server (locally, for instance), and uploading to your web host when all’s good, then make sure to create the very same user account & database name in phpMyAdmin on your local server. Otherwise, you’ll need to change your connection file in Dreamweaver® to post & use the site on the web host.
Download this tutorial as a pdf.
1. Login to the account control panel on the web host.
2. In the Databases category, click on the MySQL icon.
3. Click on the CREATE NEW DATABASE link in the following screen.
4. The screen should refresh to show that the database has been created. When it does, the User Name will appear.
Your database has now been created. Now that it exists, connecting to it is a snap.
5. Click the OPEN MANAGER button to the right of the user name. The following dialogue opens, showing an example connection via php & mysql code.
If you wish to write your own sql queries & such, use this as your guide. If you use Dreamweaver® & phpMyAdmin for connections & queries, get the username & dbname from here, combine these with your password & accomplish the connection in Dreamweaver®.
Note: should you be developing on another server (locally, for instance), and uploading to your web host when all’s good, then make sure to create the very same user account & database name in phpMyAdmin on your local server. Otherwise, you’ll need to change your connection file in Dreamweaver® to post & use the site on the web host.
Download this tutorial as a pdf.