mysql服务无法启动，ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)解决办法

最新推荐文章于 2024-07-29 21:20:30 发布

seven_0-0

最新推荐文章于 2024-07-29 21:20:30 发布

阅读量2w

点赞数

分类专栏： MySql 文章标签： mysql error2003

本文链接：https://blog.csdn.net/her__0_0/article/details/79181241

版权

当尝试启动MySQL服务时遇到ERROR 2003 (HY000)，博主通过查看错误日志发现问题出在data文件夹的数据上。解决方案是使用`mysql –initialize`命令重新初始化data文件夹，但在执行前需注释my.ini中datadir配置并删除旧的data目录。执行后，MySQL服务成功启动。

摘要由CSDN通过智能技术生成

很长时间没有用数据库了，之前在电脑上安装了mysql，但是许久不用，最近用起来却是问题多多，提示无法启动服务器，却没有报任何错误。使用net start mysql 启动服务提示如下图：这里写图片描述
使用mysql –console命令查看错误信息。如下：

D:\Program Files (x86)\mysql\bin>mysqld –console
2018-01-27T07:04:33.136066Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2018-01-27T07:04:33.136066Z 0 [Warning] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2018-01-27T07:04:33.136066Z 0 [Warning] ‘NO_AUTO_CREATE_USER’ sql mode was not set.
2018-01-27T07:04:33.136566Z 0 [Note] –secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-01-27T07:04:33.137072Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 8304 …
2018-01-27T07:04:33.153080Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-01-27T07:04:33.155586Z 0 [Note] InnoDB: Uses event mutexes
2018-01-27T07:04:33.158582Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-01-27T07:04:33.162091Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-01-27T07:04:33.166087Z 0 [Note] InnoDB: Number of pools: 1
2018-01-27T07:04:33.168093Z 0 [Note] InnoDB: Not using CPU crc32 instructions
201