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

Editor to share with you how to solve the problem of 1067 errors when MySQL starts. I hope you will get something after reading this article. Let's discuss it together.

Solve the 1067 error when MySQL starts [@ more@] somehow, when installing MySQL, I have to wait endlessly at that step of configuration, so I have to finish the task, but there is a 1067 error when I start 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!

After reading this article, I believe you have a certain understanding of "how to solve the problem of 1067 errors when MySQL starts". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

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.