MYSQL service cannot be started. Message 1067 is displayed. solution:

I had to vomit that the mysql version was too unstable. I restarted the mysql service and crashed.

Baidu has a lot of blogs and can modify my. ini files. Nima doesn't work. Google is still reliable. The solution is to uninstall it and reinstall it.

Re-download the noinstall version of mysql5.6 and decompress it to the D folder named mysql.

1. Enter cmd and enter the command: SC delete mysql prompts that if the delete service is success, the service is successfully deleted;

2. Back up the my. ini file in the mysql5.1 folder and delete all the mysql5.1 folders.
(My. ini file configuration please read my blog http://blog.csdn.net/jkxqj/article/details/9986731 ).

3. Start-> Run-> regedit. Check whether the registry has been deleted.
HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ Eventlog \ Application \ MySQL directory Deletion
HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet002 \ Services \ Eventlog \ Application \ MySQL directory Deletion
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application \ MySQL directory deletion (I did not find the directory when I uninstalled it, and it was still completely uninstalled after I skipped it .)

After uninstalling it, reinstall it.

4. The new folder is named mysql. Modify the my. ini file that was previously backed up and paste it directly here.

# Example MySQL config file for small systems.## This is for a system with little memory (<= 64M) where MySQL is only used# from time to time and it's important that the mysqld daemon# doesn't use much resources.## MySQL programs look for option files in a set of# locations which depend on the deployment platform.# You can copy this option file to one of those# locations. For information about these locations, see:# http://dev.mysql.com/doc/mysql/en/option-files.html## In this file, you can use all long options that a program supports.# If you want to know which options a program supports, run the program# with the "--help" option.# The following options will be passed to all MySQL clients[client]#password= your_passwordport= 3306socket= MySQLdefault-character-set=utf8# Here follows entries for some specific programs# The MySQL server[mysqld]port= 3306socket= MySQLcharacter-set-server=utf8skip-external-lockingkey_buffer_size = 16Kmax_allowed_packet = 1Mtable_open_cache = 4sort_buffer_size = 64Kread_buffer_size = 256Kread_rnd_buffer_size = 256Knet_buffer_length = 2Kthread_stack = 128Kbasedir=D:\mysqldatadir=D:\mysql\data# Don't listen on a TCP/IP port at all. This can be a security enhancement,# if all processes that need to connect to mysqld run on the same host.# All interaction with mysqld must be made via Unix sockets or named pipes.# Note that using this option without enabling named pipes on Windows# (using the "enable-named-pipe" option) will render mysqld useless!# #skip-networkingserver-id= 1# Uncomment the following if you want to log updates#log-bin=mysql-bin# binary logging format - mixed recommended#binlog_format=mixed# Uncomment the following if you are using InnoDB tables#innodb_data_home_dir = C:\\mysql\\data\\#innodb_data_file_path = ibdata1:10M:autoextend#innodb_log_group_home_dir = C:\\mysql\\data\\# You can set .._buffer_pool_size up to 50 - 80 %# of RAM but beware of setting memory usage too high#innodb_buffer_pool_size = 16M#innodb_additional_mem_pool_size = 2M# Set .._log_file_size to 25 % of buffer pool size#innodb_log_file_size = 5M#innodb_log_buffer_size = 8M#innodb_flush_log_at_trx_commit = 1#innodb_lock_wait_timeout = 50[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updates[myisamchk]key_buffer_size = 8Msort_buffer_size = 8M[mysqlhotcopy]interactive-timeout

5. Run cmd as an administrator. Enter disk D, and then enter the Copy command below:

D: \ mysql \ bin \ mysqld-install mysql -- defaults-file = "D: \ mysql \ my. ini"

Servicesuccessfully installed is displayed. The installation is successful.

Then open the service window (enter services. msc in the running box to open the service window, and then you can find the mysql service)

6. Start the MySQL Service
Net start mysql
MySQL service is starting

5. log on to the MySQL server
Mysql-u root-p
Enterpassword: (set the root password by yourself. Note: The administrator username of MySQL is root, and the password is blank by default .)