GoDaddy and your MySql Database

by Marvin 6. February 2009 19:39

I have been a customer of GoDaddy's for awhile now, and at this point, I have gotten pretty comfortable with their tools to manage my websites and databases.  I forget sometimes that it was VERY painful for me in the beginning.  I suppose I repressed the memory of how frustrated I was when I got my first ASP.NET website built and everything worked great locally only to fail miserably when uploaded to GoDaddy.  Things like how to get my site published, get my database up and running, connect my published pages to my remote database, etc - these were all tricky for me to figure out the first time.  So, I am going to put together some articles on the basic stuff that you have to know to be able to get your data-driven ASP.NET website up and running using MySQL on GoDaddy.  This article will cover setting up a MySql database on GoDaddy. It will be the first in a series that I will put in the category "GoDaddy Basics".

Let's start at the start.  Assuming you have an account, let's login (see picture below, click on any of the pictures in this article to see them full-size).   



After logging in, hover over the "Hosting" tab in the green navigational menu across the top and click on "My Hosting Account" under "Hosting Management" in the drop-down menu that appears under Hosting (see picture at right).  This will open up a screen that shows your account.  Your account number and name are at the top.  Over on the right, GoDaddy puts some basic instrructions about the page you are on.  In the middle of the screen, you should see your primary domain name listed under "Hosting Account" and a link on the right under "Control Panel" that says "Manage Account".  When I login to my account, this is almost always where I am headed.  There may be a faster way to get there, but I haven't figured it out yet.  Click on this to open up GoDaddy's Hosting Control Center for your account (see picture below).
  If you are in Internet Explorer, this will probably launch a new window.  In Firefox, you get a new tab.  By the way, some of these concepts are repeated from another article I did on Implementing ASP.NET Membership on GoDaddy using MySql.  I would encourage you to check that article out after finishing this one.  Ok, once you are in the Hosting Control Panel, hover over the "Databases" tab at the top and click on "MySql" in the drop-down menu underneath it (see picture below).


At the next screen, you will see a list of your MySql databases.  It's very likely that there will be no databases in your list unless you have already created some.  Assuming you haven't yet, let's create a new one.  Click on the "Create Database" button in the top right (see below).
 


At the next screen, you will input the name of your database (which will also be the username for the only account on the database), your password, and a description (see below).  It's probably worth noting here that GoDaddy shared hosting does NOT support multiple accounts on a single database.  You get one and only one account for each database, and that account has full privileges on the database. 

After you click ok, you'll be taken back to the previous screen where your MySql databases are listed.  You should now see the new database that you created in the list with a status of "Pending Setup" displayed next to it (see picture below).  In my experience, it doesn't take GoDaddy long to setup a database.  I usually go do something else for thirty minutes and come back to find it done.  

And that's it.  You've now got a MySql database setup on GoDaddy.  My next article will cover accessing the new database and moving data back and forth between your local MySql database and the new remote database on GoDaddy.

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

GoDaddy Basics | Web Development

Comments

Add comment


(Will show your Gravatar icon)  

  Country flag

biuquote
  • Comment
  • Preview
Loading



About the author

I am a junior-level C# .NET developer living in Nashville, TN.  I'm currently working in biomedical informatics, developing a web service, a MySql database, and a web application.  Every week or so, I spend hours trying to figure out how to do something, and after I find the solution, I really want to make sure I don't go through that exercise again.  I love to write.  It helps me to remember things.  So, I use this blog as a way to document those painful lessons as I learn them.  It has already helped me to be able to refer back to them.  I hope some of these will save someone else some time as well.