mySQL

[skidpanda]

Hi folks,

I just bought some new hosting which allows 1 mySQL database.

I know what a mySQL database is but how do i connect to it etc?
I have a hostname, username and password. What program would I use to connect to the database to like make tables etc? I have followed mySQL tutorials but none i've found actually tells u the basics of it, they just say 'connect to your mySQL database' as if you should automatically know how to do it? Maybe i'm just being dumb!

Hope someone can help!

Cheers :run:

[Jubba]

USE PHP!!

to connect use:



$linkID = mysql_connect("HOST", "USER", "PASS");
mysql_select_db{"DBNAME", $linkID);


then you can perform your queries.

[eyezberg]

Most providers, when they include a database, also install phpMyAdmin, which is an interface, built with php, to let you do anything in a simple way with your db; should it not be installed (i'd be surprised..), you can do that that yourself, it's available for free at sourceforge.

[Jubba]

yes but phpMyAdmin makes you lazy so that you don't know how to code in case you need to in the future...

[eyezberg]

true, but

What program would I use ...

[Jubba]

I didn't see that. :) lol

[skidpanda]

Thanks for all your reply's!

Any chance you could give me a few basic steps what I have to do to use that phpmyadmin? Or a link to a tutorial?

Thanks very much. :run:

[Jubba]

phpMyAdmin is point and click. It does everything for you.

[eyezberg]

check
http://www.phpmyadmin.net/

and the php setup files in the downloads for the book "PHP for Flash" @ www.friendsofed.com in the books "code" section to see how php interacts with a database...