Summary of apache+php+mysql installation and configuration methods_PHP tutorial

The entire installation process is as follows:

1. First install apache: the version I installed is: httpd-2.2.16-win32-x86-openssl-0.9.8o.msi
Website: http://www .apache.org/dist/httpd/binaries/win32/
The installation and configuration of apache was relatively smooth, there is nothing much to say.
How to change the file path:
In the installation directory of the file, mine is: D:Program FilesApache Software FoundationApache2.2conf, open httpd.conf and search: DocumentRoot "C:/web/apache/htdocs" will Change the value to the publishing path you want, for example:
DocumentRoot “D:/WWW”
Then there is another place that needs to be modified
Search: Directory “C:/web/apache/htdocs”
Modify to: Directory “D:/WWW”
This changes the publishing path of the file to d:www.

2. Install PHP: Version: php-5.3.3-Win32-VC6-x86

Website: http://windows.php.net/download/
Will be downloaded Unzip the compressed package to D:php, and rename php.ini-development in this directory to php.ini
Open php.ini and modify it as follows:
Search: error_reporting = E_ALL
Modify: error_reporting =E_ALL & ~E_NOTICE
Here is to modify the error reporting level, E_ALL is to report all errors, and E_NOTICE is to report messages that should be paid attention to during runtime, such as initialized variables.
Search for: extension_dir = "./"
Modify: extension_dir = "D:php5ext", configure the path of the extension library
Search for: ;extension=PHP_MySQL.dll, remove the preceding semicolon: extension=PHP_MySQL .dll
Search: ;extension=PHP_mysqli.dll Remove the preceding semicolon: extension=PHP_mysqli.dll
Search;session.save_path = "/tmp", change it to an existing path, session.save_path = "D:/mysql/session", or create a tmp folder in the release directory.
The basic settings of PHP are completed

3. Configure apache to load PHP

Open the installation directory of apachede, mine is: D:Program FilesApache Software FoundationApache2.2confextra, create a new one named: httpd -The text file of php5.conf, open and add the following content
view sourceprint?LoadModule php5_module "C:webphpphp5apache2_2.dll"
AddType application/x-httpd-php .php
AddType application/x-httpd- php-source .phps
DirectoryIndex index.php
PHPIniDir "C:webphp"
Then open: C:webapacheconfhttpd.conf, add a line at the end of the file:
Include conf/extra/httpd-php5 .conf
Restart Apache, open the directory: D:WWW, create a new file: index.php, enter the content:
phpinfo();
?>
Use Open http://localhost in the browser and test whether the installation is successful
Step 4: Install mysql: version mysql-5.1.49-win32
Website: http://dev.mysql.com/downloads/mysql/ #downloads
There is a configuration wizard after installation. There is no strict set of options. You can just set it according to your own needs. It will have little impact.
Combined with Apache and php, as mentioned before, let me say it again, find php.ini in the php installation directory, remove the ";" before ";extension=php_mysql.dll", and load the mysql module. Save, close, and restart apache.
Step 5: Install phpMyAdmin
I downloaded it from Huajun Software: http://www.onlinedown.net/soft/2616.htm
Unzip it and put it in the release directory, which is the D previously set :WWW;Change config.default.php in the libraries folder
Make the following modifications:
1 Find the following two lines for password
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
Fill your mysql password into $cfg['Servers'][$i][ 'password'] = ''; inside single quotes
2 Search $cfg['PmaAbsoluteUri'] and set it to the phpMyAdmin directory path, such as: http://localhost/phpMyAdmin/
I don’t know how to do the above Is it necessary because I later changed it back and it still works.

Summary of problems encountered during the configuration process:
1. The installation of mysql failed.
The general situation is that the previous Mysql uninstallation was incomplete. How can I cleanly uninstall mysql? In DOS environment
1, first stop the mysql service: Stop Mysql: net stop mysql, you can also right-click "My Computer" - Management - Services - Find the mysql service, and then stop it .
2. Uninstall under DOS c:mysqlbinmysqld-nt --remove
//c:mysqlbin is the specific path. If you want to completely delete mysql, first end the mysql process and then uninstall mysql.
The two additional DOS instructions are:
Start Mysql: net start mysql
Installation: c:mysqlbinmysqld --install //Pay attention to modify the specific path
3, and delete the remaining mysql files directly .
If you accidentally deleted all mysql files and did not perform the above uninstall function before, you can use the following method:
1. Stop the mysql service, the same as above 1.
2. Manually delete the registration Table information:
Clear your MYSQL service in the registry (regedit). There are several places: HKEY_LOCAL_MACHINESYSTEMControlSet001ServicesEventlogApplicationMySQL directory deletion; HKEY_LOCAL_MACHINESYSTEMControlSet002ServicesEventlogApplicationMySQL directory deletion; HKEY_LOCAL_MACHINESYSTEMControlSetServicesEventlogApplicationMySQL directory deletion;
As shown in the figure:

Just restart.

Second, there was a problem when connecting to the database:

"Because the connecting party did not reply correctly after a period of time or the connected host did not respond", I was testing mysql