# My first database

**URL:** <https://forum.kirupa.com/t/my-first-database/58576>\
**Category:** programming\
**Created:** [July 23, 2004, 5:30pm UTC](https://forum.kirupa.com/t/my-first-database/58576 "2004-07-23T17:30:09Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![keljnr](https://avatars.discourse-cdn.com/v4/letter/k/e8c25b/32.png) [@keljnr](https://forum.kirupa.com/u/keljnr)\
**Post date:** [July 23, 2004, 5:30pm UTC](https://forum.kirupa.com/t/my-first-database/58576/1 "2004-07-23T17:30:09Z")

</div>

Hey people,  
Im wanting to look more into databases, can any please suggest a decent tutorial from setting up apache to creating the actual database.

Does Apache act as a “virtual/local server” until you upload it to the web?

(im using windows xp)

Or if you can help yourself please do so.

hope ya can help,

cheers:}

---

<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:** [July 23, 2004, 6:01pm UTC](https://forum.kirupa.com/t/my-first-database/58576/2 "2004-07-23T18:01:11Z")

</div>

Apache is a web server. You are more than likely going to be looking into mySQL as the database server.

If you want to control web output from a database you will need some kind of server scripting language, like PHP.

So look at installing mySQL, Apache, PHP in that order and read the docs before doing so. It is well explained how to set these up, so read first, install, then if you have any questions you can post and ask.

To help you out:

[www.apache.org](http://www.apache.org) \<-- Most common on webhosts: 1.3.29 or .30 (where ever is current), but 2.x.x serires is just fine.  
[www.mysql.com](http://www.mysql.com) \<-- go with 4.0 series. 4.1 is still beta if I can remember.  
[www.php.net](http://www.php.net) \<-- php5 is now in production mode. You can install this, but if you are going to be messing with prebuilt applications, like a forum, read their info about php5 as most applications work on php5, but some don’t. Otherwise use 4.3.x, which for the next month or two, most hosts will still 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:** [July 23, 2004, 8:18pm UTC](https://forum.kirupa.com/t/my-first-database/58576/3 "2004-07-23T20:18:32Z")

</div>

i am already using 5 series of mysql. ( when using it with the mysql.dll it works nicely. )

before that worked long time with 4.1 Never had troubles.

---

<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:** [July 23, 2004, 8:21pm UTC](https://forum.kirupa.com/t/my-first-database/58576/4 "2004-07-23T20:21:21Z")

</div>

Perfect tutorial: [http://www.ricocheting.com/server/index.html](http://www.ricocheting.com/server/index.html) ! 🙂

---

<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:** [July 23, 2004, 8:38pm UTC](https://forum.kirupa.com/t/my-first-database/58576/5 "2004-07-23T20:38:00Z")

</div>

My recommendation if you are building applications for web, and plan on hosting them with a company that you do not have control over what is installed on it, is to work closely with the versions they have installed. You can work with whatever version you want, I currently use php5 at home on my dev server, but knowing that if I upload any php scripts that use php5 functions, it will crash.

There are some significant changes between versions of servers, some you might never notice, and others that you can’t live without, so going backwards compatible can be a headache.

But if you are just learning than stick with what works best 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:** [July 24, 2004, 12:43pm UTC](https://forum.kirupa.com/t/my-first-database/58576/6 "2004-07-24T12:43:18Z")

</div>

cheers fellas, i knew i could count on this forum!!

Think i’ll give that tutorial a whirl voetsjoeba.

---

<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:** [July 24, 2004, 1:36pm UTC](https://forum.kirupa.com/t/my-first-database/58576/7 "2004-07-24T13:36:28Z")

</div>

Just a note on the posts above: You should install those in the order of Apache, PHP, MySQL. And also to be sure, download the versions of those which says stable release.

Good luck 😉

---

<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:** [July 24, 2004, 5:43pm UTC](https://forum.kirupa.com/t/my-first-database/58576/8 "2004-07-24T17:43:15Z")

</div>

It’s usually Mysql, Apache PHP…

---

<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:** [July 24, 2004, 5:49pm UTC](https://forum.kirupa.com/t/my-first-database/58576/9 "2004-07-24T17:49:35Z")

</div>

i dont have a database program, like access. do ya know of ne other software i can download, free.

---

<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:** [July 24, 2004, 6:38pm UTC](https://forum.kirupa.com/t/my-first-database/58576/10 "2004-07-24T18:38:02Z")

</div>

Ahem… MySQL [www.mysql.com](http://www.mysql.com)