개인적인 정리

MySQL 8.0 초기화 본문

DB/MYSQL

MySQL 8.0 초기화

yeon.Biju 2020. 1. 10. 14:46

MySQL 8.0.x.x Initializing the Data Directory

 

https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html

 

MySQL :: MySQL 8.0 Reference Manual :: 2.10.1 Initializing the Data Directory

2.10.1 Initializing the Data Directory After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Secti

dev.mysql.com

 

[ERROR] --initialize specified but the data directory exists. Aborting.

 

-->

In this case, remove or rename the data directory and try again.

An existing data directory is permitted to be nonempty if every entry has a name that begins with a period (.).

 

그래서 mysql_data 폴더의 모든 데이타 삭제하고 아래와 같이 실행

 

#/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql --datadir=/usr/local/mysql_data --user=mysql

'DB > MYSQL' 카테고리의 다른 글

CMake Error: CMAKE_C_COMPILER not set, after EnableLanguage  (0) 2020.01.10
Could NOT find Git (missing: GIT_EXECUTABLE)  (0) 2020.01.10
bash: cmake: 명령을 찾을 수 없습니다...  (0) 2020.01.10
MySQL 설치(소스 컴파일)  (0) 2020.01.10
MySQL 다운로드  (0) 2020.01.07
Toad Edge 다운로드  (0) 2020.01.07
mysql 다른 포트로 접속  (0) 2019.12.23
MySQL 버전 확인  (0) 2019.12.23
Comments