The installation of Apache and mysql is relatively simple. The main thing is to ensure that port 80 is not occupied before installation, such as iis. If apache mysql has been installed before, stop running phpmyadmin first. The main problem is the configuration file. Change the Config under the Libraries directory in the phpMyAdmin installation directory. Copy default.php to the root directory of PHPmyAdmin and rename it Config.inc.php; open Config.inc.php with Notepad and change "$cfg['blowfish_secret'] = '';" to "$cfg['blowfish_secret" '] = 'Anything is OK';", where "" is added by me to avoid ''. You can change "anything is OK" in the following "''" to anything else, but it cannot be "Nothing" ", which can also be a space; then change "$cfg ['Servers'][$i]['auth_type'] = 'config';" to "'$cfg['Servers'][$i]['auth_type '] = 'cookie';"; The last step is to click Save.
More detailed setting method:
Search $cfg['PmaAbsoluteUri'] and set the URL of your phpmyadmin, such as: $cfg ['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/'; Note that this assumes that phpmyadmin is in the default site
Search for $cfg['blowfish_secret']in the root directory
. After setting the root password, you also need to fill it in here. For example, if the ROOT password is 123456, set it to $cfg['blowfish_secret'] = '123456';
search for $cfg['DefaultLang'] , set it to zh-gb2312;
search $cfg['DefaultCharset'], set it to gb2312;
search $cfg['Servers'][$i]['auth_type'], the default is config, which is unsafe , not recommended, it is recommended to use cookies, set it to $cfg['Servers'][$i]['auth_type'] = 'cookie';
note that if it is set to config, please set the user name and password below! For example:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user-----MySQL connection user
$cfg['Servers'][$i]['password' ] = '123456';
Open the browser and enter: http://localhost/phpMyAdmin/. If IIS and MySQL are both started, enter the user ROOT password 123456 to browse the database content.
The following error occurred in phpMyAdmin: The configuration file now requires a top-secret phrase password (blowfish_secret)
because $cfg['Servers'][$i]['auth_type'] = 'cookie';, so a password is required.
Open the config.inc.php file in the phpMyAdmin installation directory, find $cfg['blowfish_secret'] = '', and enter the password. For example: the mysql password is "666666", then set it to: $cfg['blowfish_secret'] = '666666'
At this point, all installations are completed.
TITLE: Install apache+php+mysql under xp system