Apache 2.4+PHP5.X+MYSQ5.XL Environment Building (iv)

installation of phpMyAdmin

Download

Official: http://www.phpmyadmin.net/home_page/downloads.php

Note the MySQL version supported by phpMyAdmin when downloading.

installation

Because the MySQL version is 5.0, it uses phpMyAdmin "PhpMyAdmin 4.0.10.7" multilingual version, extracted to the Apache web directory. (This is C:\WEB\Apache24\htdocs).

Set phpMyAdmin configuration file config.inc.php (location in C:\WEB\Apache24\htdocs\phpMyAdmin)

<span style= "Font-family:simsun;" ><?php/* * This was needed for cookie based authentication to encrypt password in * cookie */$cfg [' Blowfish_secret '] = ''; /* You should the change this for A more SECURE COOKIE auth! *//* * Servers configuration */$i = 0;/* * First server */$i ++;/* authentication type and Info */$cfg [' Servers '] [$i] ' auth      _type '] = ' http '; authentication method (config, HTTP or cookie based) $cfg [' Servers '] [$i] [' user '] = ' root '; $cfg [' Servers '] [$i] [' Password '] = ' root '; $cfg [' Servers '] [$i] [' extension '] = ' mysqli '; $cfg [' Lang '] = ';/* Bind to the localhost IPv4 address an D TCP */$cfg [' Servers '] [$i] [' host '] = ' 127.0.0.1 '; $cfg [' Servers '] [$i] [' connect_type '] = ' TCP ';/* User for Advanced Features */$cfg [' Servers '] [$i] [' controluser '] = ' PMA '; $cfg [' Servers '] [$i] [' controlpass '] = ';/* Advanced PhpMyAdmin Features * * $cfg [' Servers '] [$i] [' pmadb '] = ' phpmyadmin '; $cfg [' Servers '] [$i] [' bookmarktable '] = ' pma_bookmark '; $cfg [' Servers '] [$i] [' relation '] = ' pma_relation '; $cfg [' Servers ' [$i] [' table_info '] = ' pma_table_info '; $cfg [' Servers '] [$i] [' table_coords '] = ' pma_table_coords '; $cfg [' Servers '] [$i] [' pdf_pages '] = ' pma_pdf_pages '; $cfg [' Servers '] [$i] [' column_info '] = ' pma_column_info '; $cfg [' Servers ' [$i] [' history '] = ' pma_history '; $cfg [' Servers '] [$i] [' designer_coords '] = ' pma_designer_coords '; $cfg [' Servers '] [$i [' tracking '] = ' pma_tracking ', $cfg [' Servers '] [$i] [' userconfig '] = ' pma_userconfig '; $cfg [' Servers '] [$i] [' recent '] = ' Pma_recent '; $cfg [' Servers '] [$i] [' table_uiprefs '] = ' pma_table_uiprefs ';/* * End of Servers configuration */?></ Span>

Test phpMyAdmin Installation Success

Enter Localhost/phpmyadmin in the browser address bar, pop-up User login box, enter user password, login phpmyadmin, phpMyAdmin installation success!

Apache 2.4+PHP5.X+MYSQ5.XL Environment Building (iv)