apache, and sql...?

Question

Allrighty, I have an Apache server (not the newest but the second newest 2.0.4 or somethng like that) and i have php installed and configured to work with apache... but i need sql on my apache server now, i dont know much about sql nor anyone that provides it. all i know is that i need one of the following installed with the apache server:
MySQL 2.x/4.x/5.x (any of those versions)
PostgreSQL 7.x
or
MS SQL server

i need to know which of the followng i can install along side of my apache server... I dont want to install another server!

Answer 1

Make your life easy and install it in one fail swoop with WAMP. Find it here, http://www.wampserver.com/en/download.php. Better in my mind then missing something and leaving a gigantic security hole.



Good Luck!

Answer 2

You don't get it do you? Apache is an HTTP Server. MySQL is a database server. They are completely independent. There is no “get MySQL to work with Apache”. MySQL doesn't care about Apache. It doesn't do anything with it. You can write a database app without Apache. You may want to Google for databases and read the Wikipedia articles. Then you might understand what you are actually working with.



> I dont want to install another server!



You are kinda screwed. So you want a database server, without installing a database server?



> how do i get it to work with apache though, will i have to add more stuff to the httpd.config file?



No. Because MySQL has nothing to do with Apache. However, because you are using PHP to access MySQL, you may need to load up the appropriate extension. If phpinfo() doesn't show that you have MySQL enabled in PHP, you'll have to edit your php.ini file to have it included. Google for how to do so.



As always, Google and Wikipedia are your friends.

Answer 3

If you are running a Windows server, then you can install any one you want on it.



If you are running Linux/Unix/Mac OSX/FreeBSD/OpenBSD etc server then you can install any one you want, except MS SQL server (it only runs on windows).



If you are brand new to databases, I'd go with MySQL 5.x. It is more forgiving than postgreSQL. If you get serious about SQL, then you might want to check out postgreSQL again (Stored procedures, functions and triggers are amazingly helpful once you figure out what they are).

Answer 4

MySQL is probably the most common. Most web servers, especially personal servers, use Apache/MySQL. They'll work together just fine.

Answer 5

Stop here and just get WAMP. It has been completely wonderful for me. It'll install Apache, PHP, MySQL, SQLite, and other things. You won't regret it.

Answer 6

There are tutorials here for MySQL, Apache, etc: http://crazy-coderz.net

Answer 7

use MySQL. AFAIK it's free and will work well on a unix based server.