apache+mysql+php Quick Install

Although a lot of online, or here to record their own installation process, and some experience, do not have to install and then everywhere to find.

First say MySQL, because he can say completely independent and Apache, PHP installation is not directly related. Now MySql5.0 has been officially released, a number of new features, the database has a basic functionality already has, such as views, subqueries, stored procedures and so on. (MySQL official website for http://www.mysql.com, I think this should everyone should not know it ^ ^, find download Download a setup program.) ), click on the installation program, according to his one step choice, set good parameters. Smoothly installed on it, the new version of the installation process has been greatly improved, has even been registered service, the previous version is only to help you copy the program file, here by the way the previous installation services: In the operation of the input C:\mysql\bin\mysqld-nt.exe- Install. (C:\mysql\j is the path to the MySQL installation.) No problem installed, command line input: net start MySQL start service can be.

If the previous version is Mysql4.1, all programs will not be able to connect to MySQL for the following reasons:

Client does not support authentication protocol problem resolution when mysql4.1 above version connection

shell> MySQL

Client does not support Authenticationprotocol requested

by server; Consider upgrading MySQL client

The official version of the statement: MySQL 4.1 and up uses a authenticationprotocol based on a password hashing of that are algorithm with that Used by older clients. .....

If you are experiencing the above problems after you upgrade MySQL to version 4.1, make sure your mysqlclient is 4.1 or later. (If there is a problem with windows, you can just skip to the solution below, because MySQL is installed with Windows client and server)

Please use one of the following two methods

One

mysql> SET PASSWORD FOR
-> ''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;

The red section above please revise according to oneself actual situation ....

When you do this, the connection will be normal!

Now the version has a very clear configuration file, as if the location is not very sure and very few people use, now very good in the MySQL root directory of the My.ini option is also rich. Related to see for themselves, stating that a datadir= "E:/document/data" This is the data directory, so you can move to other places.

This is the end of MySQL.