今天安装MySQL,一直停留在starting server这里,百度查找解决方法,发现有很多方法。
一:在运行中输入services.msc打开服务窗口,然后找到mysql服务,双击打开属性窗口,选择 “登录” 选项卡,然后登录身份 选择 “本地系统帐户” 然后点击启动,点击应用,然后mysql安装过程就可以顺利往下执行啦。
二:打开C:\ProgramData\MySQL\MySQL Server 5.5\data下面的.err文件看看,用记事本打开,内容是否类似于:
150318 10:33:48 [Note] Plugin 'FEDERATED' is disabled.
150318 10:33:48 InnoDB: The InnoDB memory heap is disabled
150318 10:33:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150318 10:33:48 InnoDB: Compressed tables use zlib 1.2.3
150318 10:33:48 InnoDB: Error: unable to create temporary file; errno: 2
150318 10:33:48 [ERROR] Plugin 'InnoDB' init function returned error.
150318 10:33:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150318 10:33:48 [ERROR] Unknown/unsupported storage engine: INNODB
一:在运行中输入services.msc打开服务窗口,然后找到mysql服务,双击打开属性窗口,选择 “登录” 选项卡,然后登录身份 选择 “本地系统帐户” 然后点击启动,点击应用,然后mysql安装过程就可以顺利往下执行啦。
二:打开C:\ProgramData\MySQL\MySQL Server 5.5\data下面的.err文件看看,用记事本打开,内容是否类似于:
150318 10:33:48 [Note] Plugin 'FEDERATED' is disabled.
150318 10:33:48 InnoDB: The InnoDB memory heap is disabled
150318 10:33:48 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150318 10:33:48 InnoDB: Compressed tables use zlib 1.2.3
150318 10:33:48 InnoDB: Error: unable to create temporary file; errno: 2
150318 10:33:48 [ERROR] Plugin 'InnoDB' init function returned error.
150318 10:33:48 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150318 10:33:48 [ERROR] Unknown/unsupported storage engine: INNODB