Here we use PhpMyadmin to manage the Mysql database Gui.
Version used:
Apache_2.2.11-win32-x86-no_ssl (msi installation)
Mysql-essential-5.1.23-rc-win32 (msi installation)
Php-5.2.8-Win32
PhpMyAdmin-3.0.0-all-languages
1. Apache
1.1 install Apache
When installing Apache, it is the same as other software. you can enter the Domain Name at will, and you can modify the Domain Name through httpd. conf later.
1.2 configure Apache
1.2.1 configure DocumentRoot // Configure the root directory of the website file
DocumentRoot "F: \ phpmyadmin \ phpMyAdmin-3.0.0-all-languages"
Pay attention to port issues. You can use httpd. conf to modify the port as shown in figure
Listen 80
Note: When editing the \ conf \ httpd. conf configuration, note that the path is "/" not "\"
After modification, you can enable localhost or 127.0.0.1 for verification.
1.2.2. Php module php5apache2_2.dll
LoadModule php5_module "c:/php/php5apache2_2.dll" // specify the file path of this module
AddType application/x-httpd-php. php // specify the php file processing type.
AddType application/x-httpd-php. htm // specify the php file processing type
*************************************** **************************************** *
2. Php
As a scripting language container, PHP is added to Apache as a module of Apache. When the browser requests a PHP page, Apache calls the php module to process the php source code and returns the processing result to the browser.
2.1 install PHP
Extract php-5.2.8-Win32
Decompress the package. Note that the target folder name cannot contain spaces, Chinese characters, and non-ASCII codes.
2.2 Php configuration
2.2.1 modify doc_root as the website file path (same as DocumentRoot in Apache)
Doc_root = "f: \ web"
2.2.2
Specify the path of the extension module (dll) to ext in the Php decompression Directory. Php supports Mysql and mssql through the extension module.
Extension_dir = "c: \ php \ ext"
2.2.3 modify the extension module such as mysql and remove the comment to make it valid. the modified extension module is as follows:
; Extension = php_bz2.dll
Extension = php_curl.dll
; Extension = php_dba.dll
; Extension = php_dbase.dll
; Extension = php_exif.dll
; Extension = php_fdf.dll
Extension = php_gd2.dll
; Extension = php_gettext.dll
; Extension = php_gmp.dll
; Extension = php_ifx.dll
Extension = php_imap.dll
; Extension = php_interbase.dll
; Extension = php_ldap.dll
Extension = php_mbstring.dll
; Extension = php_mcrypt.dll
; Extension = php_mhash.dll
; Extension = php_mime_magic.dll
; Extension = php_ming.dll
; Extension = php_msql.dll
; Extension = php_mssql.dll
Extension = php_mysql.dll
Extension = php_mysqli.dll
; Extension = php_oci8.dll
; Extension = php_openssl.dll
; Extension = php_pdo.dll
; Extension = php_pdo_firebird.dll
; Extension = php_pdo_mssql.dll
; Extension = php_pdo_mysql.dll
; Extension = php_pdo_oci.dll
; Extension = php_pdo_oci8.dll
; Extension = php_pdo_odbc.dll
; Extension = php_pdo_pgsql.dll
; Extension = php_pdo_sqlite.dll
; Extension = php_pgsql.dll
; Extension = php_pspell.dll
; Extension = php_shmop.dll
; Extension = php_snmp.dll
; Extension = php_soap.dll
; Extension = php_sockets.dll
; Extension = php_sqlite.dll
; Extension = php_sybase_ct.dll
; Extension = php_tidy.dll
; Extension = php_xmlrpc.dll
; Extension = php_cmd.dll
; Extension = php_zip.dll
Note: Because php is not installed, you need to copy php_mysql.dll, libmysql. dll, and php. ini (modified) to windows, windows \ system32, and windows \ system32 directories.
Pay attention to the following issues:
Add the system environment variable path c: \ php; C: \ php \ ext.
After installing Php, you can use the following script to verify the PHP information:
Phpinfo ();
?>
**************************************** **************************************** ***
3. install Mysql
1. select "BEST" and "UTF-8" when selecting language items.
2. when you use MySQL Server Instance Config Wizard to initialize the configuration, the current password is empty by default, and the generated username is root by default.
3. after the installation is complete, you can use the MySQL Command Line Client for verification.
*************************************** ********************
4. install PhpMyadmin
PhpMyadmin connects to the mysql database to perform graphical interface management (GUI) through logging on to the website)
4.1 installation
4.1.1 decompress all phpmyadmin files to the root directory of the website, that is, the access file is in the root directory, which facilitates the direct use of the phpadmin path
4.1.2 modify the verification type in config. sample. inc. php to HTTP
/* Authentication type */
$ Cfg ['servers'] [$ I] ['auth _ type'] = 'http ';
After phpmyadmin is complete, you can use [url] http: // localhost/phpmyadmin [/url] for testing and database management.