Install MySQL, prompt after successful installation, start service, prompt error 1067
Previously tip: MySQL installation files and configuration files are not placed under the program file folder.
Workaround: Place the My.ini file cut under the program file folder.
The configuration of the My.ini file is as follows:
#以下是复制内容, it's not a copy.
[Client]
port=3306
Default-character-set=utf8
#客户端字符类型, consistent with the service side, recommended UTF8
[Mysqld]
port=3306
Character_set_server=utf8
#服务端字符类型, it is recommended that UTF8
Basedir=c:\soft\mysql-5.6.17-winx64
#解压根目录
Datadir=c:\soft\mysql-5.6.17-winx64\data
#解压根目录 \data
Sql_mode=no_engine_substitution,strict_trans_tables
[Winmysqladmin]
C:\soft\mysql-5.6.17-winx64\bin\mysqld.exe
#解压根目录 \bin\mysqld.exe
#以上是复制内容, it's not a copy.
Environment variable Configuration
My Computer-Properties-advanced-environment variables-NEW
Variable Mysql_home value D:\wamp\mysql
Find the variable path edit, add it at the back;%mysql_home%\bin
MySQL cannot start the service, error 1067