黑窗口 安装mysql
net start mysql
提示启动成功
可是输入 net stop mysql 却提示没有启动的mysql
服务中的mysql 服务显示正在运行,刷新一下 就停止了
找到mysql安装目录 在data文件下查找 err文件
报错信息如下
01:51:17 UTC - mysqld got exception 0x80000003 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong…
7ff72d6d1d82 mysqld.exe!my_sigabrt_handler()[my_thr_init.cc:372]
7ffcca4e1881 ucrtbase.dll!raise()
7ffcca4e2851 ucrtbase.dll!abort()
7ff72d8f9812 mysqld.exe!ut_dbg_assertion_failed()[ut0dbg.cc:99]
7ff72d8f75c3 mysqld.exe!trx_sys_close()[trx0sys.cc:585]
7ff72d85e01f mysqld.exe!srv_shutdown()[srv0start.cc:3648]
7ff72d7b5924 mysqld.exe!innodb_shutdown()[ha_innodb.cc:1410]
7ff72c6aff47 mysqld.exe!ha_finalize_handlerton()[handler.cc:724]
7ff72c6dc8aa mysqld.exe!plugin_deinitialize()[sql_plugin.cc:1116]
7ff72c6e1f42 mysqld.exe!reap_plugins()[sql_plugin.cc:1187]
7ff72c6e0c18 mysqld.exe!plugin_shutdown()[sql_plugin.cc:2034]
7ff72c67e8f1 mysqld.exe!clean_up()[mysqld.cc:2504]
7ff72c690f76 mysqld.exe!unireg_abort()[mysqld.cc:2372]
7ff72c68fb85 mysqld.exe!setup_conn_event_handler_threads()[mysqld.cc:3199]
7ff72c692d62 mysqld.exe!win_main()[mysqld.cc:7591]
7ff72c68caa5 mysqld.exe!mysql_service()[mysqld.cc:7687]
7ff72c68d0ec mysqld.exe!mysqld_main()[mysqld.cc:7903]
7ff72dd02d48 mysqld.exe!__scrt_common_main_seh()[exe_common.inl:288]
7ffccb5374b4 KERNEL32.DLL!BaseThreadInitThunk()
7ffcccdc26a1 ntdll.dll!RtlUserThreadStart()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
找到mysql 的my.ini文件
在[mysqld]下面加上一行
innodb_force_recovery = 1
然后保存my.ini,重启mysql
启动成功 恢复了
innodb_force_recovery 改回0
之后记得把my.ini里的 innodb_force_recovery 值改回0,重启mysql。