Topic Chapter Lesson

Q

initializing database에서 설치가 오류가 납니다.

조회 1626

좋아요 0

2022년 6월 9일

김용배

LV

12

김용배 Profile

김용배

LV

12

김용배 Profile

댓글 4개

2022년 6월 9일
log 탭에 쓰여있는걸 복붙하셔서 답변으로 첨부해주실 수 있을까용?
2022년 11월 16일
Beginning configuration step: Writing configuration file Saving my.ini configuration file... Saved my.ini configuration file. Ended configuration step: Writing configuration file Beginning configuration step: Updating Windows Firewall rules Adding a Windows Firewall rule for MySQL80 on port 3306. Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 3306" protocol=TCP localport=3306 dir=in action=allow 확인됨 Successfully added the Windows Firewall rule. Adding a Windows Firewall rule for MySQL80 on port 33060. Attempting to add a Windows Firewall rule with command: netsh.exe advfirewall firewall add rule name="Port 33060" protocol=TCP localport=33060 dir=in action=allow 확인됨 Successfully added the Windows Firewall rule. Ended configuration step: Updating Windows Firewall rules Beginning configuration step: Adjusting Windows service Attempting to grant Network Service require filesystem permissions. Granted permissions. Adding new service New service added Ended configuration step: Adjusting Windows service Beginning configuration step: Initializing database (may take a long time) Attempting to run MySQL Server with --initialize-insecure option... Starting process for MySQL Server 8.0.20... Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" --console --initialize-insecure=on --lower-case-table-names=1... mysqld: File '.\誘쇱젙??bin.index' not found (OS errno 2 - No such file or directory) '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. C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.20) initializing of server in progress as process 13072 The designated data directory C:\ProgramData\MySQL\MySQL Server 8.0\Data\ is unusable. You can remove all files that the server added to it. Aborting C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.20) MySQL Community Server - GPL. Process for mysqld, with ID 13072, was run successfully and exited with code 1. Failed to start process for MySQL Server 8.0.20. Database initialization failed. Ended configuration step: Initializing database (may take a long time)
2022년 11월 16일
컴퓨터명 변경 및 window service name을 MySQL80_로 언더바 추가하니 되었습니다 감사합니다
2022년 11월 16일
제가 요 질문 답변에 남긴걸 참고해서 해보시겠어용?
A
2개의 답변이 있어요
커뮤니티 파트너 채택
랑이
LV. 209

채택된 답변 수 2,594

2022년 6월 10일
김용배
LV. 12
2022년 6월 9일

(주) 코드잇

대표강영훈, 이윤수

개인정보보호책임자강영훈

이메일support@codeit.kr

사업자 번호313-86-00797

통신판매업제 2019-서울중구-1034 호

주소서울특별시 중구 청계천로 100 시그니쳐타워 동관 10층 코드잇