1067 error resolution for MySQL

Source: Internet
Author: User

Author Fbysss
Msn:jameslastchina@hotmail.com
Blog:blog.csdn.net/fbysss
Statement: This article is prepared by FBYSSS, reproduced please indicate the source
Keyword: mysql,1067 error
My machine does not know why, when installing MySQL, a configuration that step on the endless waiting, had to end the task, but when the start of MySQL 1067 error prompts. Uninstall, there are still endless waiting, the solution is to finish the task first, then click ' Change ', repair, and then uninstall.
Later read an article, said that the system user rights are not added to the problem, my installation directory D:\MySQL5.0, a look at D disk is really only everyone, and C disk has system's read and write permission. So it was installed once in the C:\programe files inside, it really works. Originally prepared to draw a conclusion, in order to confirm, unloading and then installed again placed under the C:\, but not. Uninstall and then install c:\programe files also die. How to do will die in the configure that step. What to do?
Fortunately remember the success of that time more generated a my.ini in the MySQL directory, so on the colleague machine copy a My.ini to modify, and put it alone in a place as a backup. Its contents are as follows:

#Uncomment or ADD only the keys, you know.
#Read the MySQL Manual for instructions

[Mysqld]
basedir=d:/mysql5.0/
#bind-address=127.0.0.1
Datadir=d:/mysql5.0/data
#language =d:/usr/local/mysql/share/your Language Directory
#slow Query log#=
#tmpdir #=
#port =3306
#set-variable=key_buffer=16m
[Winmysqladmin]
Server=d:/mysql5.0/bin/mysqld-nt.exe
User=root
password=
And then in the bin directory
Mysqld-nt-remove
Mysqld-nt-install
net start MySQL
Ok!
It seems that the most crucial problem is the My.ini.
Such a small problem, incredibly took me a morning's time! The first thing to fix the problem is to write down the process for the victim's reference.

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.