MYSQL服務無法啟動,提示信息1067解決辦法 不得不吐槽mysql5.1這個版本實在是太不穩定了,重啟了一下mysql服務就崩潰了。 百度了好多博客,說什麼修改my.ini文件就行了,尼瑪都不行,還是谷歌靠譜,解決辦法就是徹底卸載之後重新安裝。 重新下載了mysql5.6的noinstall版本,解壓縮到D盤文件夾命名為mysql。 1、 進入cmd 輸入命令: sc delete mysql 提示若是delete service success,證明刪除服務成功; 2、備份mysql5.1文件夾下的my.ini文件後直接將mysql5.1文件夾全部刪除)。 3、開始->運行-> regedit 看看注冊表裡這幾個地方刪除沒有 HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\Eventlog\Application\MySQL 目錄刪除 HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services\Eventlog\Application\MySQL 目錄刪除 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\MySQL 目錄刪除(我卸載的時候沒有找到,略過後仍達到完全卸載的目的。) 卸載完之後就重新安裝吧。 4、新的文件夾名字為mysql,將之前備份的my.ini文件修改一下,我這裡就直接貼我的了。
[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、以管理員身份運行cmd。進入D盤,然後輸入復制以下命令: D:\mysql\bin\mysqld -install mysql --defaults-file="D:\mysql\my.ini" 出現Servicesuccessfully installed.表示安裝成功。 然後打開服務窗口(在運行框中輸入services.msc即可打開服務窗口,然後可以找到mysql服務了) 6.啟動MySQL服務 net start mysql MySQL服務正在啟動 5.登陸MySQL服務器 mysql -u root -p Enterpassword:(root密碼自己設置就好了,注意:MySQL的管理員用戶名為root,密碼默認為空。)