<p>服务器: Window Server 2012</p><p>进入Mysql时出现如下问题</p><p>ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using password: YES)
</p><p>使用命令 Mysqld --console 发现如下异常</p>
2016-06-28T01:05:00.808135Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat
a1' must be writable
2016-06-28T01:05:00.808135Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdat
a1' must be writable
2016-06-28T01:05:00.808135Z 0 [ERROR] InnoDB: Plugin initialization aborted with
error Generic error
2016-06-28T01:05:01.042465Z 0 [ERROR] Plugin 'InnoDB' init function returned err
or.
2016-06-28T01:05:01.042465Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE
ENGINE failed.
2016-06-28T01:05:01.042465Z 0 [ERROR] Failed to initialize plugins.
2016-06-28T01:05:01.042465Z 0 [ERROR] Aborting
尝试修改对应文件的读写属性,但是发现根本没啥用。于是上午搜罗了好久,终于找到一个对于我来说适用的解决方案如下链接:
http://stackoverflow.com/questions/19391182/error-in-starting-mysql-server-from-command-prompt
解决方案: 查看My.ini 文件说明
On Windows you should keep this file in the installation directory of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To make sure the server reads the config file use the startup option 。
于是拷贝My.ini文件至安装目录下。重新启动Mysql即可。