今天发现电脑里的mysqld进程的占用还不小,于是想让他先停停,因为近段时间用不到。
结果无论是MySQL Monitor 还是Workbench都Shutdown failed。(大神,别揶揄我用图形界面,我只是小白)
Workbench很粗暴,就显示
2017-02-02 16:52:55 – Server stop done.
2017-02-02 16:52:55 – Checking server status…
2017-02-02 16:52:55 – MySQL server is currently running
2017-02-02 16:52:55 – Checking server status…
2017-02-02 16:52:55 – MySQL server is currently running
Monitor的提示一闪而过,我只能多次尝试并记录如下:
Error
The service MySQL57 failed the recent status change request with the message.
The service mysql57 was not found.
他还不忘署名(QAQ):Mysql monitor
临时的解决办法:
1>结束mysqld.exe进程mysql数据库就关闭了,但,但但,但但但怎么启动啊!!!
2>我注意到他是说service mysql57 not found,于是我在服务里找到了MySQL57(为什么他会说找不到真是奇了怪了)
通过启动和停止这个服务就可以启动和关闭MySQL数据库了
真正的解决办法:
最后我发现原来在菜单栏Service-Manage Access Configuration中的System Profile选项卡下Windows Service Name一项填的是MySQL,然后,然后我把它改成MySQL57就好惹。QAQ
P.S.感觉自己好弱智啊,竟然是这么简单的一个问题QAQ