Windows 下搭建 MySQL+Apache +PHP 环境

#修改前：
Define SRVROOT "c:/Apache24" #这里根据自己解压的路径填写
ServerRoot "${SRVROOT}"

#修改后：
Define SRVROOT "E:\php\httpd-2.4.37-o102q-x64-vc14-r2\Apache24"
ServerRoot "${SRVROOT}"

#修改根目录（站点），这里使用默认的路径也可以，路径不要太长
#修改前：
DocumentRoot "${SRVROOT}/htdocs"
<Directory "${SRVROOT}/htdocs">

#修改后：
#DocumentRoot "${SRVROOT}/htdocs"
DocumentRoot "E:/php/SmartCommunity"
#<Directory "${SRVROOT}/htdocs">
<Directory "E:/php/SmartCommunity">

#修改DirectoryIndex 文件类型
#修改前：
<IfModule dir_module>
    DirectoryIndex index.html
</IfModule>

#修改后：
<IfModule dir_module>
    DirectoryIndex index.html index.php index.htm
</IfModule>

#修改监听的端口
#修改前：
#Listen 12.34.56.78:80
Listen 80

#修改后：（根据自己需要修改）
#Listen 12.34.56.78:80
Listen 8080

#修改ServerName
#修改前：
#ServerName www.example.com:80

#修改后：
ServerName localhost:8080

修改 extension_dir，目录路径，根据自己的安装目录修改

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
;extension_dir = "${phphome}\ext"
extension_dir = "E:/php/php-5.6.39-Win32-VC11-x64/ext"

.ini 文件 ；代表注释，以下打开一些注释：

extension=php_bz2.dll
extension=php_curl.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_gmp.dll
extension=php_intl.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
extension=php_exif.dll
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8_12c.dll  ; Use with Oracle Database 12c Instant Client
extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll

; The MIBS data available in the PHP distribution must be installed. 
; See http://www.php.net/manual/en/snmp.installation.php 
;extension=php_snmp.dll

extension=php_soap.dll
extension=php_sockets.dll
extension=php_sqlite3.dll
;extension=php_sybase_ct.dll
extension=php_tidy.dll
extension=php_xmlrpc.dll
extension=php_xsl.dll

设置时区

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = Asia/Shanghai

设置openssl

[openssl]
; The location of a Certificate Authority (CA) file on the local filesystem
; to use when verifying the identity of SSL/TLS peers. Most users should
; not specify a value for this directive as PHP will attempt to use the
; OS-managed cert stores in its absence. If specified, this value may still
; be overridden on a per-stream basis via the "cafile" SSL stream context
; option.
openssl.cafile= cacert.pem

LoadModule rewrite_module modules/mod_rewrite.so

#php5.6，配置apache支持php
#在apache中以module的方式加载php,配置库的关联

LoadModule php5_module "E:/php/php-5.6.39-Win32-VC11-x64/php5apache2_4.dll"
<IfModule php5_module>
    PHPIniDir "E:/php/php-5.6.39-Win32-VC11-x64" #php的安装路径
    AddType application/x-httpd-php .php
    AddType application/x-httpd-php-source .phps
</IfModule>

<?php
	phpinfo();
?>

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8

[mysqld]

#设置3306端口
port = 3306

#设置mysql的安装目录
basedir=D:\mysql-5.7.23-winx64

# 设置mysql数据库的数据的存放目录
datadir=D:\mysql-5.7.23-winx64\data

# 允许最大连接数
max_connections=200

# 服务端使用的字符集默认为8比特编码的latin1字符集
character-set-server=utf8

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

mysqld --initialize

mysqld install

#启动mysql服务
net start mysql

#关闭mysql
net stop mysql

#移除mysql服务
mysqld --remove

mysql -u root -p mysql (默认)

skip-grant-tables

use mysql;
update user set authentication_string=password("你设置的密码") where user = "root";
\q;

参考链接：
https://blog.csdn.net/YOYOYOHUI/article/details/81433894
https://blog.csdn.net/self_realian/article/details/56489120?locationNum=5&fps=1
http://my.oschina.net/lsfop/blog/496181