5. Install phpmyadmin
Download phpMyAdmin, unzip it to D:\php\phpmyadmin, and create a new site or virtual directory in IIS to point to the directory for access through the WEB address. Here, the phpMyAdmin virtual directory that establishes the default site points to the D:\php\phpMyAdmin directory is found and opened through http://localhost/phpmyadmin/ access (open with the writing board to avoid black code) D:\php\phpMyAdmin directory, make the following modifications: (phpMyAdmin-2.8 or above version is in the libraries directory)
$cfg['blowfish_secret']= �
Searching for $cfg['Servers'][$i]['auth_type'], default to config, is unsafe and not recommended. It is recommended to use cookies, set to $cfg['Servers'][$i]['auth_type'] = 'cookie';
Note that if you set it to config here, please set the username and password below! For example:
$cfg['Servers'][$i]['user'] �
$cfg['Servers'][$i]['password'] = '';
Search $cfg['DefaultLang'] and set it to zh-gb2312 ;
Search $cfg['DefaultConnectionCollation'] (if present) Change its settings to gbk_unicode_ci
Search $cfg['DefaultCharset'] and set it to gbk ;
Open the browser and enter: http://localhost/phpMyAdmin/. If both IIS and MySQL have been started, enter the user ROOT password (if there is no password set, the password will be left blank) to enter the phpMyAdmin database management.
First click on permission to enter user management, delete users whose ROOT and host are not localhost and re-read the user permission table. Here you can also modify and set the ROOT password, add other users, etc.
6. Directory structure and permission configuration.
D:\php——————D:\MySQL
+—————+———————+———————+
php4(php5) tmp Zend phpMyAdmin
D:\php is set to full permissions for administrator and SYSTEM, and no other users can
For the secondary directory below
php5, tmp gives EVERYONE full permissions
MySQL, Zend Administrators and SYSTEM Full permissions
phpMyAdminWEB anonymous user read run permissions
Note: The following content has not been tested and needs to be modified and improved for reference only.
Supplemental installation of Eaccelerator acceleration and caching software
Install Eaccelerator acceleration and caching software to speed up the reading and running of php files, and cache some mysql queries and php files.
Reduce the burden on the server, thereby achieving significant acceleration of the forum and improving load capacity. I have tried this software on many major websites.
The effect is very significant! The effect can be asked for several large forum webmasters that I have maintained for a long time.
Installing eaccelerator is very simple.
First, download
After decompression, one is the installation instructions and the other is the required dll file.
Copy eaccelerator_win_4.4. to c:/php/extensions/
Open c:/php/
turn up
[Zend]
zend_extension_manager.optimizer_ts="C:\Program Files\Zend\Optimizer\lib\Optimizer-2.6.0"
zend_extension_ts="C:\Program Files\Zend\Optimizer\lib\"
zend_optimizer.optimization_level=15
Replace with
[Zend]
zend_extension_ts="C:\php\extensions\eaccelerator_win_4.4."
eaccelerator.shm_size="16"
eaccelerator.cache_dir="c:\temp"
="1"
="1"
eaccelerator.check_mtime="1"
="0"
=""
eaccelerator.shm_max="0"
eaccelerator.shm_ttl="0"
eaccelerator.shm_prune_period="0"
eaccelerator.shm_only="0"
="1"
eaccelerator.compress_level="9"
zend_extension_manager.optimizer_ts="C:\Program Files\Zend\Optimizer\lib\Optimizer-2.6.0"
zend_extension_ts="C:\Program Files\Zend\Optimizer\lib\"
zend_optimizer.optimization_level=15
Create a folder in the root directory of the C disk, and grant this directory to everyone all permissions (in fact, as long as there are writes, modifications, and readings)
Restart IIS
If there is information about loading eaccelerator, the installation is successful.
At this point, the first step of optimization for php has been completed.
Previous page12Read the full text