이전에는 실행이 잘 되었는데 다른버전을 설치하고 나니..
자동으로 실행되던 mysql이 실행되지 않는다.
mysqld 로 실행해보니
| C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\data\' (Errcode: 2 - No such file or directory) 2019-10-02T13:52:36.921289Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-10-02T13:52:36.921289Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2019-10-02T13:52:36.922287Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 24040 ... 2019-10-02T13:52:36.929270Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\DESKTOP-PNS3EHE.lower-test 2019-10-02T13:52:36.929270Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\DESKTOP-PNS3EHE.lower-test 2019-10-02T13:52:36.930269Z 0 [ERROR] failed to set datadir to C:\Program Files\MySQL\MySQL Server 5.7\data\ 2019-10-02T13:52:36.932263Z 0 [ERROR] Aborting 2019-10-02T13:52:36.934255Z 0 [Note] Binlog end 2019-10-02T13:52:36.935252Z 0 [Note] mysqld: Shutdown complete |
해결방법은 간단하다.
cmd 누르고 services.msc 입력 또는 서비스 실행
mysql을 찾아보면 자동인데 중지로 되어있을 것임.
시작시키면 끝.
728x90
