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

This article mainly explains "how to solve the problem of mysql can not start 1067 error", the content of the explanation is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "how to solve the mysql can not start 1067 error problem" bar!

Mysql can not start 1067 error solutions: 1, open the my.ini file, modify "default-storage-engine=MyISAM"; 2, delete ib_logfile0 and ib_logfile1;3, restart MySQL's Service.

Operating environment of this article: Windows7 system, mysql5.8, DELL G3 computer

How to solve the problem that mysql cannot start 1067 error?

The solution to the failure of windows to start MySQL Service and report error 1067

Suddenly login to MySQL, there is no access or can not connect to the database, go back to the service, to open wampmysqld, found that "windows can not start MySQL service error 1067", what should I do? Let me share your experience with shrimp saplings!

Method 1:

1. Open the my.ini file, find the line default-storage-engine=InnoDB, and change it to default-storage-engine=MyISAM.

2. Delete ib_logfile0 and ib_logfile1 in the Data directory under the MySQL installation directory

3. Find the InfoDB directory specified when configuring the MySQL server and delete the ibdata1

According to the my.ini file:

# * INNODB Specific options * innodb_data_home_dir= "dvv /"

4. Restart Service of MySQL

Method 2:

Reinstall mysql, always prompt "unable to start MYSQL service, error 1067 process unexpectedly terminated and restarted, repair the registry is useless, online search, change what basedir, it is useless for me to use mysql5.8, looking around, think of before installed wampserver,pc_webserver and other integrated environment, these software will write my.ini, php.ini to the C:WINDOWS directory and set to read-only.

Solution:

Delete the my.ini file in the windows directory

Mysql was reinstalled and the service was started successfully

Method 3:

1. Execute winmysqladmin to generate my.ini file

2. Mysqld-install starts the mysql service

3. The net start mysql startup mysql service shows normal. When connecting through mysql-u root-p, the server is reported to have no startup error. Check the server service, and it is true that the mysql service has not been started. A 1067 error occurred when starting manually, and mysql has been reinstalled several times, and the error remains the same. Check that there are no errors in each configuration.

My system environment win2003 mysql version 4.0.12 solution, copy the my.ini generated by winmysqladmin to c:windows and then start mysql and then everything OK. I haven't tried this: you don't need to reconfigure it. Just click mysql.exe in the / bin directory.

Mysqld.exe

Mysqld-nt.exe

Winmysqladmin.exe

Cancle directly after the prompt box appears.

Then click winmysqladmin.exe and select the startup service on the small icon at the lower right.

Thank you for your reading, the above is the content of "how to solve the problem of mysql can not start 1067 error". After the study of this article, I believe you have a deeper understanding of how to solve the problem of mysql can not start 1067 error. The specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.