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