首页 > 编程知识 正文

MySQL服务启动后停止,mysql服务启动了连接不上

时间:2023-05-05 08:09:04 阅读:224401 作者:4706

1、
C:Program Files (x86)MySQLmysql-5.5.33-win32thdds>net stop mysql
MySQL 服务正在停止.
MySQL 服务已成功停止。

2、
C:Program Files (x86)MySQLmysql-5.5.33-win32thdds>mysql
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

3、

C:Program Files (x86)MySQLmysql-5.5.33-win32thdds>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

4、
C:Program Files (x86)MySQLmysql-5.5.33-win32thdds>mysql
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.5.33 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql>

 

 

启动mysql出现ERROR 2003问题是因为mysql服务没有启动,或者以前的mysql服务没有使用mysqld.exe -remove删除,

而重新安装mysql的路径改变了。

参考

MySQL 5.6 for Windows 解压缩版配置安装_百度经验

 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html

转载于:https://www.cnblogs.com/scnuwangjie/p/4869274.html

版权声明:该文观点仅代表作者本人。处理文章:请发送邮件至 三1五14八八95#扣扣.com 举报,一经查实,本站将立刻删除。