Clean up: quick installation of ApacheMySqlPHP

Although there are a lot of online users, I 'd like to record my own installation process here, and some experience. I don't have to install it later and try again. Let's talk about MySql first, because it can be said that it is completely independent of the installation of Apache and php. Now MySql5.0 has been

Although there are a lot of online users, I 'd like to record my own installation process here, and some experience. I don't have to install it later and try again.

Let's talk about MySql first, because it can be said that it is completely independent of the installation of Apache and php. Now MySql5.0 has been officially announced, and many new functions have been added. The basis for the functions of the database is already available, such as views, subqueries, and stored procedures. (MySql official website for http://www.mysql.com, I think this should be everyone should not know ^-^, find download an installer .), Open the installer and set the parameters according to his step. After the installation is successful, the new version of the installation program has been greatly improved, and even the services have been registered. the previous version just helps you copy the program file, here by the way, the previous method of installing the service: Entering c: \ mysql \ bin \ mysqld-nt.exe -- install in the running. (c: \ mysql \ j is the installation path of MySql .) Run the command line to start the net start mysql service.

Assume that mysql versions earlier than mysql are used. the reason why all programs cannot connect to mysql after installation is as follows:

Client does not support authentication protocol title solution displayed during connection of MySQL and later versions

Shell> mysql

Client does not support authenticationprotocol requested

By server; consider upgrading MySQL client

Official statement: MySQL 4.1 and up uses an authenticationprotocol based on a password hashing algorithm that is incompatible with thatused by older clients ......

If you encounter the above title after upgrading mysql to mysql 4.1 or later, determine that your mysqlclient is 4.1 or later. (If you have a title in WINDOWS, you can directly jump to the following to see the solution. because MYSQL is installed with the client and server in WINDOWS)

Apply either of the following methods

1:

Mysql> SET PASSWORD

-> ''Some _ user'' @ ''some _ host'' = OLD_PASSWORD (''newpwd '');

Second:

Mysql> UPDATE mysql. user SET Password = OLD_PASSWORD (''newpwd '')

-> WHERE Host = ''some _ host'' AND User = ''some _ user '';

Mysql> flush privileges;

Correct the red part above according to your actual situation ....

After doing so, the connection will be normal!

The current version has a very clear configuration file, and it seems that the previous status is not very determined and few people are using it. now it is very good that my. ini options under the mysql root directory are also very rich. Let's take a look at it. clarify that a datadir = 'E:/document/data' is a data directory, so that you can move it to other places.

Mysql ends here.

Now start to install Apache, open the installer, set your own parameters, the default port is 80, if the port has been used to change to other such as 8080. Installation is complete. Apache can be used, and other settings are required. you can open IE and enter http: // localhost: 80. if the page is normal, verify that the installation is successful.

Install php and unzip the file to C: \ php or the directory you want: all DLL files in the \ Php \ Dlls Directory (if PHP5 does not have this directory, copy all the DLL files in the directory. if you do not know it, delete it .) Copy to the Windows System directory (% windir % \ System). Note that % windir % \ System refers to System variables. generally, win 98 is c: \ windows/system, 2000/xp/2003 is c: \ windows (winnt) \ system32. However, in special cases, I used XP and installed it once, but copied it to system32 won't work on the system. I don't know the reason, so I 'd like to remind you. Set C: \ Php. ini-recommended, php4ts. dll (php5ts. dll) copy to the Windows directory (% windir %) and rename it to php. ini and open it with the text editor. Compile the three rows for setting extension_dir and session. save_path to make them consistent with the ones shown below. replace InstallDir with the name of your Apache installation directory.