第一个错误:错误代码error2003的解决办法
![](https://image.shishitao.com:8440/Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xMjI2NTk5Mi04NjQyODY1ODQ5YjA4MDUxLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzEwMjMvZm9ybWF0L3dlYnA%3D.png?w=700&webp=1)
出现这种错误一般是mysql服务没有启动,在cmd中输入net start MySQL就可以启动服务,但是输入之后出现
![](https://image.shishitao.com:8440/Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xMjI2NTk5Mi04MTM2Nzg2YWJhZTkxYjcwLnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzcxNC9mb3JtYXQvd2VicA%3D%3D.png?w=700&webp=1)
说明没有 MySQL这个服务,我们打开计算机管理 查找服务,找到 MySQL服务,
![](https://image.shishitao.com:8440/Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xMjI2NTk5Mi02MTE1OTJhZDBlYTFiZDI3LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzEwMDMvZm9ybWF0L3dlYnA%3D.png?w=700&webp=1)
发现服务名是MySQL80(服务名是根据自己电脑中安装的mysql版本),这时候我们点击启动服务,然后在命令行里输入net start MySQ80,如果还是不行
![](https://image.shishitao.com:8440/Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xMjI2NTk5Mi1kMTRjZWZmZmVkYTYzMjQ0LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzUwMC9mb3JtYXQvd2VicA%3D%3D.png?w=700&webp=1)
这时候,我们只需要退出cmd,重新使用管理员身份进入,再次输入net start MySQ80即可
![](https://image.shishitao.com:8440/Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy8xMjI2NTk5Mi1hMTEyNTZkOGQ0MDZmZjY1LnBuZz9pbWFnZU1vZ3IyL2F1dG8tb3JpZW50L3N0cmlwfGltYWdlVmlldzIvMi93LzQ5Ni9mb3JtYXQvd2VicA%3D%3D.png?w=700&webp=1)
第二个错误:too many connections问题
项目好好的,某天启动疯狂报错:
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMTk2ODE5NC8yMDIwMDQvMTk2ODE5NC0yMDIwMDQyMjExNTYzMzQ3Ni04MzkyNTUzNTgucG5n.png?w=700&webp=1)
报错很明显,数据库太多链接,应该是关闭项目后资源没有及时释放。
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMTk2ODE5NC8yMDIwMDQvMTk2ODE5NC0yMDIwMDQyMjExNTkyMTkxMC00NTQ3NjYwNTcucG5n.png?w=700&webp=1)
解决方法如下:
首先,重启MySQL服务。
进入MySQL,输入命令:show variables like \'max_connections\';
![](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWcyMDIwLmNuYmxvZ3MuY29tL2Jsb2cvMTk2ODE5NC8yMDIwMDQvMTk2ODE5NC0yMDIwMDQyMjEyMDMyNTk5MS0xMzg5MjI1NTcwLnBuZw%3D%3D.png?w=700&webp=1)
最大连接数修改大一点
set
global max_connections=1000;
注意事项:使用上面的可以进行临时解决问题,想要一直开启就需要去MySQL下面的my.ini文件里修改max_connections即可。
MySQL安装路径查询命令:
进入mysql命令行输入:show variables like
"%char%"
;