MySQL 1067 error handling

Collapsed, unloaded, loaded, loaded, unloaded, found N, multiple methods, or failed to start MySQL service. Today, I finally found a solution!

When re-installing, clear the content in the default datadir. These files are generally placed in:

C: \ Documents ents and Settings \ All Users \ Application da Ta \ mysql \

 

 

When I installed MySQL for the first time, I learned to learn Java and installed it along with sun glassfish. At that time, I could use it as soon as I installed it. When I tried to use it separately last night, I did not remember the password, so I uninstalled and reinstalled it. The reinstallation process has a small setback.

If you want to install the automatic MySQL service after Reinstallation, this step is always unavailable and the error 1067 is displayed. Check the official installation manual. The problem is also mentioned above, which may be caused by the non-default C:/program files /... then MySQL configuration file my. INI has no corresponding updates. For example, in the original article (in fact, my situation is not as mentioned in the document. You can skip this section at the bottom of my solution): note that my. the INI location is not as stated in the document in % WINDIR % (I installed MySQL 5.1 server community edition), which is generally in the root directory of the installation. In the figure, mysqldis related to the mysqlservice, and the corresponding mysqld.exe can be found in the bin directory under the root directory of installation. Related Parameters include mysqld -- remove and mysqld -- install. To uninstall and install the MySQL service. In addition, if the value of datadir is changed, it is best to move all the data in the original location to a new directory (recommended in this document ). But I actually checked my. ini configuration file. The values of basedir and datadir are correct. The problem does not seem to be there. I re-installed MySQL this morning and installed it according to the default directory. When the configuration page is displayed, a new root password is set (only two lines are required and the current password is not required, this indicates that it is a new installation), and I will know that it can be used this time, so I immediately uninstalled the current one and re-installed it. When re-installing, clear the content in the default datadir. These files are generally placed in: C: \ Documents ents and Settings \ All Users \ Application da Ta \ mysql \ Keep important databases and delete other databases. Select another path for installation. Another scenario is that you can run the following command after the recommended installation to verify the correctness of the installation. C: \> "C: \ Program Files \ mysql \ MySQL Server 5.1 \ bin \ mysqld" -- Console In fact, if the MySQL service is successfully installed, this command will report an error. Haha, because the MySQL service has locked the necessary resources, this command will not succeed. Or you can run Net stop MySQL This command is used to terminate the MySQL service and then try the preceding command. Run the following command to restart the MySQL service: Net start MySQL