# mySQL

**URL:** <https://forum.kirupa.com/t/mysql/13842>\
**Category:** programming\
**Created:** [February 18, 2003, 8:38pm UTC](https://forum.kirupa.com/t/mysql/13842 "2003-02-18T20:38:50Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![skidpanda](https://avatars.discourse-cdn.com/v4/letter/s/f1d935/32.png) [@skidpanda](https://forum.kirupa.com/u/skidpanda)\
**Post date:** [February 18, 2003, 8:38pm UTC](https://forum.kirupa.com/t/mysql/13842/1 "2003-02-18T20:38:50Z")

</div>

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:

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 18, 2003, 9:18pm UTC](https://forum.kirupa.com/t/mysql/13842/2 "2003-02-18T21:18:57Z")

</div>

USE PHP!!

to connect use:

```php

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

```

then you can perform your queries.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 20, 2003, 9:02am UTC](https://forum.kirupa.com/t/mysql/13842/3 "2003-02-20T09:02:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 20, 2003, 3:08pm UTC](https://forum.kirupa.com/t/mysql/13842/4 "2003-02-20T15:08:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 20, 2003, 8:31pm UTC](https://forum.kirupa.com/t/mysql/13842/5 "2003-02-20T20:31:11Z")

</div>

true, but

> What program would I use …

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 20, 2003, 8:45pm UTC](https://forum.kirupa.com/t/mysql/13842/6 "2003-02-20T20:45:21Z")

</div>

I didn’t see that. 🙂 lol

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 20, 2003, 9:24pm UTC](https://forum.kirupa.com/t/mysql/13842/7 "2003-02-20T21:24:15Z")

</div>

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:

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 20, 2003, 11:14pm UTC](https://forum.kirupa.com/t/mysql/13842/8 "2003-02-20T23:14:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 21, 2003, 9:05pm UTC](https://forum.kirupa.com/t/mysql/13842/9 "2003-02-21T21:05:31Z")

</div>

check  
[http://www.phpmyadmin.net/](http://www.phpmyadmin.net/)

and the php setup files in the downloads for the book “PHP for Flash” @ [www.friendsofed.com](http://www.friendsofed.com) in the books “code” section to see how php interacts with a database…