Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the 1067 error problem when MySQL starts. It is very detailed and has a certain reference value. Interested friends must read it!

For some reason, when I installed MySQL on my machine, I waited endlessly at that step of configuration and had to end the task, but there was a 1067 error when I started MySQL. Uninstall, there is still endless waiting, the solution is to end the task, and then click 'change', repair, and then uninstall.

Later, I read an article, saying that it was a problem that the user rights of system had not been added. My installation directory D:MySQL5.0, I saw that disk D really had only everyone, while disk C had system read and write license. So I installed it once and put it in c:programe files, which really worked. I was going to come to a conclusion, but in order to confirm it, I unloaded it and put it under c: again, but it didn't work. It is not possible to install c:programe files after uninstalling it. No matter how you do it, you will die at Configure's step. What shall I do?

Fortunately, I remember that the successful one generated an extra my.ini directory in MySQL, so I copied a my.ini on my colleague's machine to modify it and put it in a separate place as a backup. Its contents are as follows:

# Uncomment or Add only the keys that you know how works.

# 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=

Then under the bin directory

Mysqld-nt-remove

Mysqld-nt-install

Net start mysql

Ok!

The above is all the contents of this article entitled "how to solve the 1067 error problem when MySQL starts up". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.