Full Install Web Server on Windows Server 2008 R2 with PHP, MySQL, PHPMyAdmin

[TABLE="class: grid, width: 800"]
[TR]
[TD]IIS 7.5 + CGI (Windows Server 2008 R2)
PHP 5.5.17-nts-Win32-VC11-x64 (enable extension: gd2, mbstring, mysql, mysqli, ldap)
MySQL 5.5.28 Win64x
phpMyAdmin-4.2.9-english

[/TD]
[/TR]
[/TABLE]
​

​

​

​

​

​

​

[TABLE="class: grid, width: 800"]
[TR]
[TD];fastcgi.impersonate = 1 ==> fastcgi.impersonate = 1
;cgi.force_redirect = 1 ==> cgi.force_redirect = 0
;extension_dir = "ext" ==> extension_dir = "C:\PHP\ext"
;date.timezone = ==> date.timezone = "Asia/Ho_Chi_Minh"
http://www.date-default-timezone-set.com/

[/TD]
[/TR]
[/TABLE]
​

​

​

​

​

[TABLE="class: grid, width: 800"]
[TR]
[TD]PHPMyAdmin cần enable những mod sau:
MySQL | extension=php_mysql
extension=php_mysqli
GD | extension=php_gd2.dll
MBSTRING | extension=php_mbstring.dll[/TD]
[/TR]
[/TABLE]


​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Config tới đây là có thể sử dụng PHPMyAdmin,
để OK hơn thì config thêm 1 chút nữa...


​

​

[TABLE="class: grid, width: 800"]
[TR]
[TD]
C:\SVUIT> mysql -u root –p
Enter password: ******

[/TD]
[/TR]
[TR]
[TD]
mysql> CREATE USER 'pma'@'localhost' IDENTIFIED BY 'pmapass';

[/TD]
[/TR]
[TR]
[TD]
mysql> GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass';

[/TD]
[/TR]
[TR]
[TD]
mysql> GRANT SELECT ON mysql.db TO 'pma'@'localhost';
mysql> GRANT SELECT ON mysql.host TO 'pma'@'localhost';
mysql> GRANT SELECT ON mysql.tables_priv TO 'pma'@'localhost';
mysql> GRANT SELECT ON mysql.user TO 'pma'@'localhost';

[/TD]
[/TR]
[TR]
[TD]
mysql> source C:\inetpub\wwwroot\phpMyAdmin\examples\create_tables.sql
(hoặc mysql> \. C:\inetpub\wwwroot\phpMyAdmin\examples\create_tables.sql
hoặc C:\SVUIT>mysql -u root -p < C:\inetpub\wwwroot\phpMyAdmin\examples\create_tables.sql
Enter password: ****** ko xuất info, dùng khi import file dữ liệu lớn)
mysql> GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO 'pma'@'localhost';

[/TD]
[/TR]
[/TABLE]



​