MYSQL Startup error 193

PHP development environment Building

A. Tools \ Environment

• WIN7 Flagship Service Pack1 64-bit

rs Seeds: http://rs.xidian.edu.cn/forum.php?mod=viewthread&tid=170364

• VC14 that is, Visual Studio

URL: http://www.microsoft.com/en-us/download/details.aspx?id=48145

• Php-7.0.0-nts-win32-vc14-x64

URL: http://windows.php.net/download/#php -7.0-ts-vc14-x64

• Httpd-2.4.17-win64-vc14

URL: http://www.apachelounge.com/download/

• Mysql-5.6.28-winx64

• URL: http://dev.mysql.com/downloads/mysql/5.6.html#downloads

Two Some ideas from the producers

1. VC14

the Vc_redist.x64.exe in the folder is an executable binary file, which can be installed directly by double-clicking.

2. PHP

• unzip the PHP package to D:\Program files\, modify the folder php-7.0.0-nts-win32-vc14-x64

to php-7.0.0

• D:\Program files\ php-7.0.0\php.ini-production copy One and rename it to php.ini; Open with Notepad, modify some extensions

; Extension_dir = "ext" ———— >extension_dir = "ext"

; Extension=php_mbstring.dll ———— >extension=php_mbstring.dll

; Extension=php_mysqli.dll ———— >extension=php_mysqli.dll

; Extension=php_pdo_mysql.dll ———— >extension=php_pdo_mysql.dll

3. D:\Program files\php-7.0.0 and D:\ProgramFiles\ php-7.0.0\ext Join the environment variable PATH

• Apache

• Unzip the httpd-2.4.17-win64-vc14.zip file and copy the sub-file Apache24 to the "D:\ProgramFiles\" directory.

• D:\Program files\apache24\conf\httpd.conf make the following changes

A. serverroot "C:/apache24" =>serverroot "D:/programfiles/apache24 "

B. #ServerNamewww. example.com:80 ———— >ServerName www.example.com:80 (ports may be occupied, can be changed)

c. documentroot "C:/apache24/htdocs" ———— >

DocumentRoot "D:/programfiles/apache24/htdocs"

d. <directory "C:/apache24/htdocs" > ———— >

<directory "D:/program Files/apache24/htdocs" >

E. DirectoryIndex index.html=>

directoryindexindex.html index.php index.htm

F. scriptalias/cgi-bin/"c:/apache24/cgi-bin/" ———— >

scriptalias/cgi-bin/"D:/program files/apache24/cgi-bin/"

G. <directory "C:/apache24/cgi-bin" > ———— >

<directory "D:/program files/apache24/cgi-bin/" >

The above procedure can be replaced with D:/program Files/apache24 in addition to E. steps

C:/apache24 one step to complete

3) Add

LoadModule Php7_module "D:/program Files/php-7.0.0/php7apache2_4.dll"

addtypeapplication/x-httpd-php. php. html. htm

phpinidir "D:/program Files/php-7.0.0/php.ini" (Tell Apache PHP.ini's location)

• Enter D:/program files/apache24/bin Directory input Command

Httpd-k install the HTTP service to Windows

1. 4. MYSQL

2. Unzip MySQL Compressed package, modify configuration file

My path is "D:\Program files\mysql-5.6.28-winx64"

1. Open the installation directory to replicate a copy of the My-default.ini configuration file for My.ini. What to modify:

# innodb_buffer_pool_size = 128M = Innodb_buffer_pool_size =128m

# Basedir = ... ———— >basedir = "D:\Program files\mysql-5.6.28-winx64"

# DataDir = ... ———— > datadir= "D:\Program files\mysql-5.6.28-winx64\data"

1. Adding environment variables

in System Variables add after Path:"D:\ProgramFiles\mysql-5.6.28-winx64\bin"

1. Registration Services

administrator to open cmd, enter the D:\ProgramFiles\mysql-5.6.28-winx64\bin directory,

input Command "Mysqld Install"

1. Turn on the service (Administrator status)

net start MySQL

(1) Error 1067 appears, httpd.conf configuration is not correct, pay attention to check the path!

(2 )

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/78/78/wKiom1Z9GsvzxtrEAABMJVVrzUU450.png "title=" 1.png " alt= "Wkiom1z9gsvzxtreaabmjvvrzuu450.png"/>

Http://big.info/2014/01/windows-could-not-start-mysql56-service.html ,

Found D:\mmysql\mysql-5.1.55-win32\bin have a mysqld empty file, delete him can.

MYSQL Startup error 193