MySQL cannot start the service, error 1067

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.