Apache 2.4 + php5.x + mysq5.xl environment (4), php5.xmysq5. xl

Apache 2.4 + php5.x + mysq5.xl environment (4), php5.xmysq5. xl
Phpmyadmin Installation

Download

Http://www.phpmyadmin.net/home_page/downloads.php

Pay attention to the mysql version supported by phpmyadmin when downloading.

Install

Because the mysql version is 5.0, phpmyadmin [phpMyAdmin 4.0.10.7] multi-language version is used here to decompress the package to the Apache web directory. (Here is C: \ WEB \ Apache24 \ htdocs ).

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

<span style="font-family:SimSun;"><?php/* * This is needed for cookie based authentication to encrypt password in * cookie */$cfg['blowfish_secret'] = ''; /* YOU SHOULD 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 and 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>

Phpmyadmin is successfully installed.

Enter localhost/phpmyadmin in the address bar of the browser. The user logon box is displayed. Enter the user password and log on to phpmyadmin. phpmyadmin is installed successfully!