윈도우 mysql 설치 오류(서비스가 오류를 보고 하지 않았습니다) 질문입니다.

버전 : 윈도우용 mysql-5.7.10

C드라이브 경로 아래에서 압축 풀고 환경변수 추가하여 실행하였음.

윈도우에서 mysql을 설치 할 일이 있어서 설치했는데 net start mysql 명령어를 입력하니 다음과 같이 오류가 뜹니다.

MySQL 서비스를 시작합니다..

MySQL 서비스를 시작할 수 없습니다.

서비스가 오류를 보고하지 않았습니다.

NET HELPMSG 3534을(를) 입력하면 도움말을 더 볼 수 있습니다.

다음은 로그파일을 확인한 결과입니다.

2016-02-03T09:20:35.385133Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-02-03T09:20:35.385133Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.

2016-02-03T09:20:35.385133Z 0 [Note] MySQL (mysqld 5.7.10) starting as process 4068 ...

2016-02-03T09:20:35.391133Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2016-02-03T09:20:35.392133Z 0 [Note] InnoDB: Uses event mutexes

2016-02-03T09:20:35.392133Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier

2016-02-03T09:20:35.392133Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3

2016-02-03T09:20:35.393133Z 0 [Note] InnoDB: Number of pools: 1

2016-02-03T09:20:35.393133Z 0 [Note] InnoDB: Not using CPU crc32 instructions

2016-02-03T09:20:35.413134Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2016-02-03T09:20:35.422135Z 0 [Note] InnoDB: Completed initialization of buffer pool

2016-02-03T09:20:35.445136Z 0 [Note] InnoDB: Highest supported file format is Barracuda.

2016-02-03T09:20:35.472137Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2016-02-03T09:20:35.473138Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2016-02-03T09:20:35.546142Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.

2016-02-03T09:20:35.550142Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.

2016-02-03T09:20:35.551142Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.

2016-02-03T09:20:35.554142Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 1209999

2016-02-03T09:20:35.556142Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\mysql-5.7.10-winx64\mysql-5.7.10-winx64\data\ib_buffer_pool

2016-02-03T09:20:35.557142Z 0 [Note] Plugin 'FEDERATED' is disabled.

2016-02-03T09:20:35.557142Z 0 [Note] InnoDB: not started

MySQL: Table 'mysql.plugin' doesn't exist

2016-02-03T09:20:35.559142Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

2016-02-03T09:20:35.560143Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160203 18:20:35

2016-02-03T09:20:35.561143Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2016-02-03T09:20:35.563143Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key

2016-02-03T09:20:35.566143Z 0 [Note] Server hostname (bind-address): '*'; port: 3306

2016-02-03T09:20:35.568143Z 0 [Note] IPv6 is available.

2016-02-03T09:20:35.569143Z 0 [Note]   - '::' resolves to '::';

2016-02-03T09:20:35.569143Z 0 [Note] Server socket created on IP: '::'.

2016-02-03T09:20:35.571143Z 0 [Warning] Failed to open optimizer cost constant tables

2016-02-03T09:20:35.573143Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

2016-02-03T09:20:35.574143Z 0 [ERROR] Aborting

2016-02-03T09:20:35.575143Z 0 [Note] Binlog end

2016-02-03T09:20:35.575143Z 0 [Note] Shutting down plugin 'ngram'

2016-02-03T09:20:35.576143Z 0 [Note] Shutting down plugin 'partition'

2016-02-03T09:20:35.576143Z 0 [Note] Shutting down plugin 'BLACKHOLE'

2016-02-03T09:20:35.577144Z 0 [Note] Shutting down plugin 'ARCHIVE'

2016-02-03T09:20:35.577144Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'

2016-02-03T09:20:35.578144Z 0 [Note] Shutting down plugin 'MRG_MYISAM'

2016-02-03T09:20:35.578144Z 0 [Note] Shutting down plugin 'MyISAM'

2016-02-03T09:20:35.579144Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

2016-02-03T09:20:35.579144Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'

2016-02-03T09:20:35.580144Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'

2016-02-03T09:20:35.580144Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'

2016-02-03T09:20:35.581144Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'

2016-02-03T09:20:35.581144Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'

2016-02-03T09:20:35.582144Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'

2016-02-03T09:20:35.582144Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'

2016-02-03T09:20:35.583144Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'

2016-02-03T09:20:35.584144Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'

2016-02-03T09:20:35.584144Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'

2016-02-03T09:20:35.585144Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'

2016-02-03T09:20:35.585144Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'

2016-02-03T09:20:35.586144Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'

2016-02-03T09:20:35.586144Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'

2016-02-03T09:20:35.587144Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'

2016-02-03T09:20:35.587144Z 0 [Note] Shutting down plugin 'INNODB_METRICS'

2016-02-03T09:20:35.588144Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'

2016-02-03T09:20:35.588144Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'

2016-02-03T09:20:35.589144Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'

2016-02-03T09:20:35.590144Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'

2016-02-03T09:20:35.590144Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'

2016-02-03T09:20:35.591144Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'

2016-02-03T09:20:35.591144Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'

2016-02-03T09:20:35.592144Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'

2016-02-03T09:20:35.592144Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'

2016-02-03T09:20:35.593144Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2016-02-03T09:20:35.593144Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'

2016-02-03T09:20:35.594144Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'

2016-02-03T09:20:35.594144Z 0 [Note] Shutting down plugin 'INNODB_TRX'

2016-02-03T09:20:35.595145Z 0 [Note] Shutting down plugin 'InnoDB'

2016-02-03T09:20:35.595145Z 0 [Note] InnoDB: FTS optimize thread exiting.

2016-02-03T09:20:35.596145Z 0 [Note] InnoDB: Starting shutdown...

2016-02-03T09:20:35.696150Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\mysql-5.7.10-winx64\mysql-5.7.10-winx64\data\ib_buffer_pool

2016-02-03T09:20:35.698150Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160203 18:20:35

2016-02-03T09:20:37.025226Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210018

2016-02-03T09:20:37.026226Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2016-02-03T09:20:37.026226Z 0 [Note] Shutting down plugin 'MEMORY'

2016-02-03T09:20:37.027226Z 0 [Note] Shutting down plugin 'CSV'

2016-02-03T09:20:37.027226Z 0 [Note] Shutting down plugin 'sha256_password'

2016-02-03T09:20:37.028227Z 0 [Note] Shutting down plugin 'mysql_native_password'

2016-02-03T09:20:37.029227Z 0 [Note] Shutting down plugin 'binlog'

2016-02-03T09:20:37.030227Z 0 [Note] MySQL: Shutdown complete

조언좀 부탁드립니다;;

게시글

[난해주님참가자 게시글114댓글337총합451★★@workman729]

음...! 윈도우 사용 하지 않은지 오래라 다 까먹었나 봅니다.

로그를 보니 사용자 테이블을 만들지 않으신 것 같은 데 mysql_secure_installation이 윈도우에선 설치되지 않는가요??

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

위의 두 로그를 보면 plugin을 사용하려면 mysql을 업그레이드 하라는 로그와
유저 테이블이 생성되지 않아서 실행되지 않는 것 같습니다.

음...! 전혀 생각나지 않는 것을 보니 저도 윈도우를 사용해 봐야 하는지 곰곰히 생각하게 됩니다.
아!~~~~ 옛날이여....^^ 청춘은 그냥 흘러간듯 합니다.

[둥둥이참가자참가자 게시글41댓글32총합73★★@seojh1431]

댓글 감사합니다. zip 으로 압축 형식으로 된 파일로 받았을 ? 위와 같은 현상이었는데

msi로 설치하니 잘 되는군요! 감사합니다

[글쓴이]

답변