How To Create a MySQL Database on GoDaddy Account

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?

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

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.

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!

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

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

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);

?>

@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!

@anomynous

Please elaborate to make your comment more constructive

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?

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?

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

@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…

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.

After creating database on Godaddy going through the Launch>Database>MySql>Create Database.
Should there be a database folder in our ftp when we create it?

5 to 10 minutes, my ass. Try 90 minutes to 2 hours as of late.

[...] ايضا وجدت هذا الشرح لطريقة اضافة قاعدة من هنا [...]

What does this para mean? Can we put our database on goDaddy or not? If it is there, can we update it? This means nothing to me. Thanks.

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.

Another question. You say that problems with GoDaddy are why you prefer cPanel hosting, but when I Googled cPanel hosting, it shows me about 8 sites that do it, including GoDaddy. Can you clarify this, please?

@Jackie: this means that you cannot query your GoDaddy database from your desktop through an ODBC connexion (using MS Access for instance). Other than that, you can do pretty everything with your MySQL database as you would with any other web host.

GoDaddy does offer cPanel but only on their VPS and dedicated servers. You get GoDaddy’s in-house control panel for all of their website hosting plans.

Sorry to have still another question. Can I go to the GoDaddy site from my desktop and query or update the database using their interfact directly on their site? I haven’t ever done this before, and we are just setting up the database now.

Yes you can, through phpMyAdmin

thank you!

Great tutorial! Managed to create some tables now I need to link them… I did work with db logic like 12 years ago (access) but has lost most of it.

Basically what I want to do is have a list of people (in one table) and a list of affiliation, lets say country.

I should make a table country with fields like countryID, country name + whatever else.

Then make a field in the people table called country which is linked to the country table?

So when a person is listed as country 1 the info from the table country can be accessed, right? That was how I used to make access dbs as far as I can remember. Is it called foreign key? (had the theory in Norwegian, not English).

and how do I set that up on GoDaddy phpmyAdmin?

@Arild: first you need to create InnoDB tables. If you initially created MyISAM tables, you can always modify the storage engine under the “Operations” tab.

Next you need to create a countryID index in your “people” table.

And finally you have to create a foreign key:

ALTER TABLE people ADD FOREIGN KEY (countryID) REFERENCES country (countryID) ON UPDATE CASCADE ON DELETE [CASCADE / RESTRICT]

Hope this helps!

Thanks for your swift response, I managed to change the tables to InnoDB tables, but when running the script (I assume I run it on the SQL-tab in phpmyAdmin) I get this error:

Error
SQL query:

ALTER TABLE player ADD FOREIGN KEY ( countryID ) REFERENCES country( countryID ) ON UPDATE CASCADE ON DELETE [ CASCADE / RESTRICT ]

MySQL said:

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘[CASCADE / RESTRICT]‘ at line 1

(My table is called player instead of people, and I use mediumint(9) as the format type… any hint?

@Arild: you need to specify either CASCADE or RESTRICT, not both.

ALTER TABLE player ADD FOREIGN KEY ( countryID ) REFERENCES country( countryID ) ON UPDATE CASCADE ON DELETE CASCADE

or

ALTER TABLE player ADD FOREIGN KEY ( countryID ) REFERENCES country( countryID ) ON UPDATE CASCADE ON DELETE RESTRICT

ah, I used CASCADE and I guess that worked, thanks! it added them as Indexes in the structure pane (on players table).

Now I need to start plugging this into html/php pages and get the results out my next question would obviously be: do I need to do anything more than just return the field countryID and if they have a 1 it would return as Spain (as that is 1 in country table) or is there any more to it?

As you see, complete novice on this part. Once I get this down I can design the shit out of it!

No this will only ensure data integrity between tables.

You’ll have to use inner joins to combine data from multiple tables.

Sorry, I meant: “You’ll have to use inner joins to combine data from multiple tables in your SQL query”.

Ok, thanks for the help. I am trying to upload the phpmyAdmin to the server (godaddy) and take it from there, seems like a bit more stuff I can do with that one (like select the fields that are linked etc for easier db updating et all)

Thansk again!

Hi,
can anybody please share their experience about the required time to restore a database on Go-Daddy? I have restored a database 4/5 hour back. but still it is showing “pending restore… “

Hunting endlessly for an answer to my DB access problem, I find this page… wow! Lots of good advice!! My site DB at GoDaddy was loaded several days ago & I’ve been in and out of their phpMyAdmin tool/etc in the hunt without much luck.

To quickly summarize, am a noob attempting to drive a new site with PHP (which I think is NOT the issue)… 2 attempts:

A) I can connect OK…
[$con=mysql_connect($host,$user,$pwd);]
but if (and only if) I don’t specify the table…
I then can’t read the DB data — my debug/echo result:
=========================
Connected: Resource id #3
SQL select * from ‘data’ where eMail=’DJ.Shave@gmail.com’ failed: []
=========================
ps: data/eMail fields are correct / in place

B) If I uncomment the code to select the table…
@ mysql_select_db($dbTable, $con)
or die (‘Selection of ‘.$dbTable.’ DB table
failed: ‘.mysql_error());
I get an access error…
=========================
Connected: Resource id #2
trying to select table data
Selection of data DB table failed:
Access denied for user ‘silentcriticdb’@'%’ to database ‘data’
=========================
Am assuming that the password (shown as “%”) works/etc, so this has to be permissions or some-such stupidity… am guessing that your comment (“Unfortunately, GoDaddy does not allow you to
connect remotely…”) might be the root?

Thanks in advance for any help you can share!
Don

Thanks for the help! GoDaddy keeps changing things, so the first few steps need to be modified, but I managed to figure it out based on the rest of the steps.

Any reason in particular you don’t allow us to name the database?

Having the database the same as the database username seems, slightly less secure then otherwise. It is a little silly of a limitation.

I mean I suppose I can understand you wanting to make it simpler to make databases, however if your manually migrating a database over it can be somewhat(very) annoying to not be able to chose it.