FREEDOM. FRIENDS. FEATURES. FIRST.
페도라 한국 사용자 모임

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

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

  • This topic has 2개 답변, 2명 참여, and was last updated 4 years, 11 months 전에 by 둥둥이. This post has been viewed 39 times
  • 만든이
    게시글
  • #13687
    둥둥이
    참가자
    • 게시글41
    • 댓글32
    • 총합73
    • ★★
    @seojh1431
    버전 : 윈도우용 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



    조언좀 부탁드립니다;;
1 답변 글타래를 보이고 있습니다
  • 글쓴이
    답변
    • #15603
      난해주님
      참가자
      • 게시글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을 업그레이드 하라는 로그와
      유저 테이블이 생성되지 않아서 실행되지 않는 것 같습니다.

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

    • #15604
      둥둥이
      참가자
      참가자
      • 게시글41
      • 댓글32
      • 총합73
      • ★★
      @seojh1431

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

      msi로 설치하니 잘 되는군요! 감사합니다
1 답변 글타래를 보이고 있습니다
  • 답변은 로그인 후 가능합니다.