Okej Now i've seen many of you having troubles with configuring and installing PHP and MySQL. Some people didn't even know where to start.
Here im starting a topic that i will be updating once in a while to help people understand how they should install everything.
Here we go:
-[ MySQL ]-
First of all you will need to download MySQL Server..
This can be downloaded from http://dev.mysql.com
There are several different releases and versions to choose from.
I will recommend MySQL 4.1.x
Download an installer package. This will make it much easier for you to install and configure the server. The good thing about MySQL installator for 4.1.x is that it has an auto configuration utility called Instance Configuration Wizard. More about it to come..
So now when youve downloaded that zip file containing Setup.exe, extract it and run. You will see a quite familliar installation wizard. I will not take you through it as i think everyone can mannage to click on 'Next' couple of times
So.. Now its installed. On a finish screen choose that you want to configure your server (there should be a checkbox, make sure its checked) and click Finish. The installer will close and an Instace Configuration Wizard will start.
There you should go throug a really easy to understand dialogs and your server will be configured automaticaly.
Concratulations, MySQL 4.1.x is installed! But wait, we are not done yet
You will need to manage your server, right? Yes.. Therefore MySQL has designed a really helpfull utility: MySQL administrator that can also be downloaded from http://dev.mysql.com
Its really easy to use and install... so i will not go into any details. Note that This utility is best on Windows XP/2003. Users of the older OS should use WinMyAdmin utility that is located in "path_to_mysql/bin/".. Thats ofcourse if you have choosen to install it.
Now... Thats not all.. You need to configure your PHP to run with MySQL.
-[ PHP ]-
So... this part will differ depending on you MySQL version and PHP version.
If you have MySQL <=4.0.x -- Everything should work as is
If you have MySQL >=4.1.x -- You will need to configure your MySQL server to use old-style password encription (USE OLD PASSWORD). This proceedure i have explained in this sticky
If you have MySQL <=4.0.x -- Edit your PHP.ini file and include php_mysql.dll dynamic extension
If you have MySQL >=4.1.x -- Edit your PHP.ini file and include php_mysqli.dll dynamic extension
Please differ mysql and mysqli as those are completely different modules.
mysqli is an Improved MySQL Extension that allows you to use all the new functions of MySQL 4.1.x
You will have to use mysqli_COMMAND instead of mysql_COMMAND
Ex.: mysqli_query instead of mysql_query
Would you like to know more about mysqli? Please check this link: http://se2.php.net/manual/en/ref.mysqli.php
More updates and information to come