How To Create a MySQL Database on GoDaddy Account

January 10th, 2009 · 14 Comments

MySQL Database on GoDaddy Web HostingCreating a MySQL database has to be one of the most common task webmasters will perform on their hosting account. In the past, I’ve shown you how to create a MySQL database using cPanel and Plesk but this time around we’ll how to do this using GoDaddy’s custom control panel.

First, start by logging into your GoDaddy account:

GoDaddy Login

Next, click on Hosting from the left menu, right below My Products:

GoDaddy Web Hosting Account

This will bring you to a page listing all your hosting accounts. Click on Manage Account next to the website you want to manage. This will open GoDaddy’s control panel in a new window. Select the Databases tab at the top:

GoDaddy Control Panel

Next, click the MySQL icon. This will bring you to a page listing all your existing MySQL databases (if you have any). Click the Create Database button at the top.

GoDaddy - Creating New MySQL Database

Fill-in the fields making sure to provide a description of your database, a database name and a strong password. As for the database version, I recommend using 5.0 unless it is not compatible with the application you need to install. Hit OK when you’re done.

You will now be brought back to the MySQL Database page where you will see the newly created database with a Pending Setup status. Try reloading the page in 5 or 10 minutes as there’s a short delay before the database is being created.

Click the Edit button from the action column, next to your newly created database. This will bring you to a page where you can find all the necessary information you’ll need to configure your application such as the hostname and database name / username.

Unfortunately, GoDaddy does not allow you to connect remotely to your MySQL Databases so you’ll need to setup your own MySQL Database server and restore a database backup if you need to do so.

14 responses so far ↓

1. Response by : David on Feb 5, 2009 at 1:20 pm

Does anyone know how to do this on a virtual dedicated server. I am able to create the mysql db but I have no clue of how to connect to it. What is the host name? or how do you find it?

2. Response by : Stephane Brault on Feb 5, 2009 at 5:19 pm

How do you want to connect to your MySQL db? Through PHP? Through an ODBC connection?

3. Response by : Brandon on Mar 19, 2009 at 3:34 pm

I have like 4 databases “pending” and they’ve been pending for about 4 hours. I think mySQL is frozen or theres a bug. Does anyone know how I can fix it that would be great thanks. Great site.

4. Response by : Stephane Brault on Mar 19, 2009 at 3:58 pm

Yeah this happens with GoDaddy. You got to contact customer support.

This is the sort of stuff that makes me prefer cPanel hosting. Everything is instant with cPanel.

Good luck!
:)

5. Response by : Brandon on Mar 19, 2009 at 4:54 pm

Thank-you I appreciate your quick and helpful response. I will have to check out cPanel for my next website.

6. Response by : charlie on Jul 6, 2009 at 6:12 pm

how do you connect to it via php? I am having issues with the server address i think.

7. Response by : Stephane Brault on Jul 7, 2009 at 8:32 am

If you are unsure about the hostname of your MySQL server, go to your GoDaddy control panel, under the Databases => MySQL

Click the Edit button from the Action column and it’ll show you the hostname of your database server.

Then you can use this code to connect to MySQL

< ?php

$hostname = 'server hostname here';
$dbuser = 'mysql username';
$dbpassword = 'mysql password';
$dbname = 'mysql database name';

mysql_connect($hostname, $dbuser, $dbpassword);
mysql_select_db($dbname);

?>

8. Response by : anomynous on Jul 31, 2009 at 10:33 am

@charlie

If you have to ask how to connect to your database you should also be asking for tutorials on how to write secure PHP!

9. Response by : The Web Hosting Hero on Aug 1, 2009 at 8:10 am

@anomynous

Please elaborate to make your comment more constructive

10. Response by : adam on Aug 22, 2009 at 7:29 am

Hello,
I couldn’t manage to connect with my website after I create mysql.
I create a basic joomla webside (1.5.14) and I have wamp server.
I just want to see this basic page on my domain adress via godaddy hosting.
I tranfered the joomla files to the host. But what else should I do?

11. Response by : Brandon on Aug 22, 2009 at 2:00 pm

After you uploaded it, did you goto the http://www.yourdomain.com/install or /admin or whatever Joomla uses and put in your SQL database info?

12. Response by : Michael B. on Sep 2, 2009 at 7:35 am

How long it takes until the databse becomes active ? I’m waiting for about 1 hour on this and the status is still pending.

13. Response by : The Web Hosting Hero on Sep 2, 2009 at 7:43 am

@Micheal: yes I know, sometimes it takes forever. Maybe you could try to create another database or contact technical support.

This is one reason why I prefer cPanel web hosts to GoDaddy…

14. Response by : JustGage on Oct 6, 2009 at 6:09 pm

Please note,

the database isn’t located at “Localhost” You can find where it is after pushing the little pencil icon next to your database.

Also, the Pending statis does go away by itself, it can take a while somtimes, I made a database, then made another one and the second one only took a few minutes but the first one is still going =p.

Leave a Comment




Posted in Control Panels · GoDaddy · Tutorials | 14 Comments

 
 
 
 
 

Tutorials by Category

 
 

Recent Comments

 
© Copyright 2010 - TheWebHostingHero.com