Mysql 1067 error Solution

Guidance:MySQLDuring installation, my machine does not know why. Once the configuration step is reached, the task has to be stopped, but it appears when MySQL is started.Error 1067Prompt. Uninstallation, there is still endless waiting. The solution is to end the task first, then click 'change', repair, and then Uninstall.

Later, I learned that the system user permission was not added. My Installation Directory D: \ MySQL5.0, I saw that D is indeed only everyone, and C has the read/write permission of system. So I installed it once and put it in c: \ programe files. I was prepared to draw conclusions. To confirm this, I installed it again and put it under c: \. However, I cannot. C: \ programe files cannot be installed after uninstallation. In Configure, all of them will die. What should I do?

Fortunately, when I was successful, I generated a directory named my. ini in MySQL. So I copied a file named my. ini on my colleague's machine and put it in a separate place as a backup.

The content is 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 = 16 M

[WinMySQLadmin]

Server = d:/MySQL5.0/bin/mysqld-nt.exe

User = root

Password =

Then, in the bin directory

Mysqld-nt-remove

Mysqld-nt-install

Net start mysql

OK!

The most critical issue is my. ini.

The solution to the 1067 error in the mysql database has been explained here. I hope you can understand the solution mentioned above after learning this article, in this way, you can easily solve similar problems in your future work.