FIRST STEP: TO DOWNLOAD APPSERV AND TO EXECUTE IT

In the first place, we will download the package AppServ 2.5.5 AppServ 2.5.5 (apache 2.0.55, MySQL 5.0.15 and PHP 5).

Once downloaded the .exe file one we click double, receiving the typical message of welcome. We will make Click in “Next”. I dont put drawing to you of this. I see you able to follow to me up to here. When it lets to us choose the installation directory, where by defect it marks “C:/appserv”, we left it as it´s and we click “Next”. In type of installation we selected “Typical”. Again “Next”.

Up to here you havent been able to lose: “Next”, “Next”, “Typical” and “Next”.

Now it´s more difficul… You watch the image of down. It puts: Please to enter your server information. Ok. In the first square we put “localhost”. In the square Administrator E-mail Address or we left it as it comes by defect or we introduce a mail account to him that will be the one of the administrator (that is yours). Field “HTTP Port” we left it as it comes by defect (80). We click in “Next”.

You watch the image of more down now. It puts: MySql Information. In Username box we will introduce a name of administrator of the database and in the Password box we introduce a password to him. You must points these data. The Charset section we left it as it comes by defect. Really, you must points these data, soon you dont say that you I did not notice it. We pressed in “Next”.

The typical bar of progress begins the installation now showing to us until it appears a screen that advise to us that it has finalized, having to leave the options that come by defect. We click “Close”.

We verified that it´s all Ok. If we have done it well when putting in our browser: http://localhost us must appear the following screen:

If this screen doesnt appear we must undownload everything and return to begin. It´s not the normal thing.

Well, the good news is that you almost have it. The bad one is that, it doesnt know because, this tiny beast install sometimes with a pair of errors. I now help to fix them you.

SECOND STEP: ALTERING the INSTALLATION (CLEANING ERRORS)

Up to here what we have is a folder in C: AppServ call, which contains as well: “Apache”, “PHP”, “MySQL” and “www”. This last folder, “www” is where we will be able to soon put some file php so that it is executed.

The errors. It opens a browser and it introduces http://localhost/phpMyAdmin (or it click there directly, we are going to surfing by your hard disk). Can you see errors in red?

1) First possible error: The director $cfg [“PmaAbsoluteUri”] MUST be in the configuration file!

Open with the notepad the following file: C: /AppServ/www/phpMyAdmin/congif.inc.php. It surfing by your hard disk to find it.

Look for (with Ctrl+B it is easier) the line $cfg [“PmaAbsoluteUri”] = '';

You have It? Change by this other: $cfg [“PmaAbsoluteUri”] = 'http://localhost/phpMyAdmin';

We have put that route between "" "". If you have installed elsewhere of where I said to you during the previous step, nothing of this will work…

2) Second more than possible error: Its configuration file contains parameters (root without password) that correspond to the predetermined privileged account of MySQL. His servant of MySQL is using these values, that constitute a vulnerability. It recommends himself to him to correct this breach of security.

Open a browser and introduce the direction http://localhost/phpMyAdmin. Click in “Privileges” (in the image with 1) and soon click in “Publishing” (to the right of the rows root and localhost, depending on the versions can be an icon with a pencil). Now in the point “Change of password” (in the image with 2) click in the option “password” and introduces a password, rewritte and click in “Continues”. Luckyly (for you), I have images of this…

In order to finish, open (with the notepad) archivoC: /AppServ/www/phpMyAdmin/congif.inc.php and looks for (with Ctrl+B) the phrase: $cfg [“Server”] [$i] [“host”].

This is the section where to specify the data by which it gave the error us. In the row “password”, between the simple " " you must introduce password that you have placed just before in the privileges of phpMyAdmin. Save and closes the file.

Open a browser again and introduce the direction http://localhost/phpMyAdmin. In principle, it must not have errors. You have an Apache with MySQL installed in house. Congratulations. Now to create a new BBDD it writes “newdatabase” (for example) in the field “to create a new database” and click “to create”. Dont forgot of the name of user and password that you put before.

You can send your comments to us about this tutorial or this page clicking here .It´s also useful to us that you suggest other programs you would like to have a tutoriall, or event can you send to us an own tutorial.