에러: Can't connect to MySQL server on '127.0.0.1'

Can't connect to MySQL server on '127.0.0.1' (10061)

> mysql_5.7.17_winx64기준

해법.

1) CMD

> 기존에 mysqld --install로 실행한 상태.

> mysqld stop  OR  mysql stop

> mysql_5.7.17_winx64\data 경로 생성후, 시도합니다.

D:\dev_lib\mysql_5.7.17_winx64\bin>mysqld stop
... ... ...
2017-03-14T13:57:32.555559Z 0 [ERROR] Aborting
 
2017-03-14T13:57:32.556060Z 0 [Note] Binlog end
2017-03-14T13:57:32.556560Z 0 [Note] mysqld: Shutdown complete
 
 
D:\dev_lib\mysql_5.7.17_winx64\bin>mysqld stop
 
D:\dev_lib\mysql_5.7.17_winx64\bin>

2) my.ini

> mysql_5.7.17_winx64\my-default.ini을 이용해서 my.ini를 생성합니다.

# *** upgrade to a newer version of MySQL.
 
[mysql]
default-character-set=utf8
 
[mysqld]
default-character-set=utf8
basedir = D:\dev_lib\mysql_5.7.17_winx64\
datadir = D:\dev_lib\mysql_5.7.17_winx64\data
port = 3306
 
max_connections=151
 
# Remove leading # and set to the amount of RAM for the most important data

3) 재실행

> mysqld start  OR  mysqld restart

기타. 참조

MySQL Workbench에서 localhost 접속시 can’t connect Mysql 5.* server on ‘127.0.0.1’ (10061) 접속 오류 해결 방법 | Dukeom's Blog

shutdown - Stop MySQL service windows - Stack Overflow

기타. 변경이력

일자	변경이력
2017-03-14	초안