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

The MYSQL service cannot be started, and the message 1067 solution has to vomit that the mysql version is too unstable. After restarting the MYSQL service, it will crash. 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 directly delete all the mysql5.1 folders ). 3. Start-> Run-> regedit. Check the Registry to delete the HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet001 \ Services \ Eventlog \ Application \ MySQL directory. Delete the HKEY_LOCAL_MACHINE \ SYSTEM \ ControlSet002 \ Services \ delete the HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Eventlog \ Application \ MySQL directory in the Eventlog \ Application \ MySQL directory (I did not find the directory when I uninstalled 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.

[plain] # 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_password  port        = 3306  socket      = MySQL  default-character-set=utf8  # Here follows entries for some specific programs  # The MySQL server  [mysqld]  port        = 3306  socket      = MySQL  character-set-server=utf8  skip-external-locking  key_buffer_size = 16K  max_allowed_packet = 1M  table_open_cache = 4  sort_buffer_size = 64K  read_buffer_size = 256K  read_rnd_buffer_size = 256K  net_buffer_length = 2K  thread_stack = 128K  basedir=D:\mysql  datadir=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-networking  server-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]  quick  max_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 = 8M  sort_buffer_size = 8M    [mysqlhotcopy]  interactive-timeout  

 

5. Run cmd as an administrator. Enter disk D, and run the following command: D: \ mysql \ bin \ mysqld-install mysql -- defaults-file = "D: \ mysql \ my. ini "appears Servicesuccessfully installed. indicates that the installation is successful. Then open the service window (enter services in the running box. msc to open the service window, and then you can find the mysql service.) 6. start MySQL Service net start mysqlMySQL service is starting 5. log on to the MySQL server mysql-u root-pEnterpassword :( you can set the root password by yourself. Note: The MySQL administrator username is root and the password is blank by default .)