安装phpstudy之后,又安装了MYSQL,导致phpstudy自带的mysql无法正常启动
在CSDN看到几种方法:
1、卸载现有的MYSQL,
2、卸载phpstudy带的mysql,
3、改mysql或者phpstudy的mysql的端口,从3306改成3307
4、改注册表的地址
5、通过系统服务(CMD输入services.msc,回车),然后找到MySQL或者MySQLa(phpstudy中的mysql),手动打开想用的服务
我的做法:
phpstudy带的mysql在“系统服务”中叫“MySQLa”,mysql的叫“MySQL”,不知道为啥,在phpstudy中无法打开mysql,得从系统服务中手动打开,想着有点麻烦,于是就找了网上的代码,抄了一个BAT文件,快捷打开想用的服务。
以下代码保存为: .bat格式的文件
打开phpstudy的mysql服务:(可能需要管理员权限,所以前两行代码是获取管理员权限)
cd /d %~dp0
%1 start "" mshta vbscript:createobject("shell.application").shellexecute("""%~0""","::",,"runas",1)(window.close)&exit
net start MySQLa
mshta vbscript:msgbox("MySQLa service run successfully , please enjoy phpstudy !",64,"infomation")(window.close)
关闭phpstudy的mysql服务:(可能需要管理员权限,所以前两行代码是获取管理员权限)
cd /d %~dp0
%1 start "" mshta vbscript:createobject("shell.application").shellexecute("""%~0""","::",,"runas",1)(window.close)&exit
net stop MySQLa
mshta vbscript:msgbox("MySQLa service has been stopped !",64,"infomation")(window.close)
打开安装的mysql服务:(可能需要管理员权限,所以前两行代码是获取管理员权限)
cd /d %~dp0
%1 start "" mshta vbscript:createobject("shell.application").shellexecute("""%~0""","::",,"runas",1)(window.close)&exit
net start MySQL
mshta vbscript:msgbox("MySQL service run successfully , please enjoy MySQL !",64,"infomation")(window.close)
关闭安装的mysql服务:(可能需要管理员权限,所以前两行代码是获取管理员权限)
cd /d %~dp0
%1 start "" mshta vbscript:createobject("shell.application").shellexecute("""%~0""","::",,"runas",1)(window.close)&exit
net stop MySQL
mshta vbscript:msgbox("MySQL service has been stopped !",64,"infomation")(window.close)
参考文献:
https://blog.csdn.net/zhu940923/article/details/88543768 https://blog.csdn.net/m0_37701410/article/details/84574233 https://blog.csdn.net/my0592/article/details/79277501 https://blog.csdn.net/u013020593/article/details/79023648 https://blog.csdn.net/xh13096/article/details/81040718 https://blog.csdn.net/weixin_42183571/article/details/80575914 https://blog.csdn.net/lijialong1313/article/details/54171535