###前提・実現したいこと
Windwos 7 64bit環境に、64bitのMysqlの環境を構築したいのですが、
mysqldからサーバーを起動する際に、Too many arguments (first extra is 'start').というエラーが発生が発生します。
今まで、xammpに付属しているmysql 32bitを使用していたのですが、
使用できるメモリサイズの関係で、64bitのmysqlに移行しようと考えています。
Mysql関係の環境構築は今までxammp任せだったため、不慣れな部分が多いですが、
ご意見の程、よろしくお願い致します。
###発生している問題・エラーメッセージ
発生手順は次の通りです。
1.管理者でコマンドプロンプトを実行
2.my.iniファイルの作成・設定
my-default.iniをコピー・リネームしてmy.iniファイルを設定。
3.mysqld.exeが格納されているbinフォルダまで移動
cd /d C:\Users\hogehoge\mysql\bin
4.初期化コマンドの実行
mysqld --initialize --console
5.サーバー起動
mysqld start
エラーの発生
mysqldからサーバーを起動する際に、Too many arguments (first extra is 'start').というエラーが発生しています。
mysqld startなので余計な引数は渡していないと思うのですが。。。
以下、エラーログの内容です。
2017-01-08T02:19:11.362212Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-01-08T02:19:11.362212Z 0 [Warning] '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.
2017-01-08T02:19:11.362212Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-01-08T02:19:11.362212Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-01-08T02:19:11.363212Z 0 [Note] mysqld (mysqld 5.7.17) starting as process 7456 ...
2017-01-08T02:19:11.376213Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-01-08T02:19:11.377213Z 0 [Note] InnoDB: Uses event mutexes
2017-01-08T02:19:11.378213Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-01-08T02:19:11.378213Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-08T02:19:11.379213Z 0 [Note] InnoDB: Number of pools: 1
2017-01-08T02:19:11.379213Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2017-01-08T02:19:11.385213Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-01-08T02:19:11.393214Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-01-08T02:19:11.432216Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-08T02:19:11.515221Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-01-08T02:19:11.516221Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-01-08T02:19:11.632227Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2017-01-08T02:19:11.644228Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-01-08T02:19:11.646228Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-01-08T02:19:11.648228Z 0 [Note] InnoDB: Waiting for purge to start
2017-01-08T02:19:11.699231Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 2535154
2017-01-08T02:19:11.701231Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\hogehoge\mysql\data\ib_buffer_pool
2017-01-08T02:19:11.701231Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-01-08T02:19:11.710232Z 0 [ERROR] Too many arguments (first extra is 'start').
2017-01-08T02:19:11.711232Z 0 [Note] Use --verbose --help to get a list of available options!
2017-01-08T02:19:11.712232Z 0 [ERROR] Aborting
2017-01-08T02:19:11.713232Z 0 [Note] Binlog end
2017-01-08T02:19:11.714232Z 0 [Note] Shutting down plugin 'ngram'
2017-01-08T02:19:11.714232Z 0 [Note] Shutting down plugin 'partition'
2017-01-08T02:19:11.715232Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2017-01-08T02:19:11.716232Z 0 [Note] Shutting down plugin 'ARCHIVE'
2017-01-08T02:19:11.716232Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2017-01-08T02:19:11.717232Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2017-01-08T02:19:11.718232Z 0 [Note] Shutting down plugin 'MyISAM'
2017-01-08T02:19:11.719232Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2017-01-08T02:19:11.719232Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2017-01-08T02:19:11.720232Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2017-01-08T02:19:11.721233Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2017-01-08T02:19:11.722233Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2017-01-08T02:19:11.722233Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2017-01-08T02:19:11.723233Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2017-01-08T02:19:11.723233Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170108 11:19:11
2017-01-08T02:19:11.724233Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2017-01-08T02:19:11.725233Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2017-01-08T02:19:11.726233Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2017-01-08T02:19:11.726233Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2017-01-08T02:19:11.727233Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2017-01-08T02:19:11.728233Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2017-01-08T02:19:11.729233Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2017-01-08T02:19:11.729233Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2017-01-08T02:19:11.730233Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2017-01-08T02:19:11.731233Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2017-01-08T02:19:11.731233Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2017-01-08T02:19:11.732233Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2017-01-08T02:19:11.733233Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2017-01-08T02:19:11.734233Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2017-01-08T02:19:11.735233Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2017-01-08T02:19:11.736233Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2017-01-08T02:19:11.736233Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2017-01-08T02:19:11.737233Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2017-01-08T02:19:11.738234Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2017-01-08T02:19:11.738234Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2017-01-08T02:19:11.739234Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2017-01-08T02:19:11.740234Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2017-01-08T02:19:11.740234Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2017-01-08T02:19:11.741234Z 0 [Note] Shutting down plugin 'InnoDB'
2017-01-08T02:19:11.742234Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-01-08T02:19:11.742234Z 0 [Note] InnoDB: Starting shutdown...
2017-01-08T02:19:11.843240Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\Users\hogehoge\mysql\data\ib_buffer_pool
2017-01-08T02:19:11.856240Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 170108 11:19:11
2017-01-08T02:19:13.166315Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2535173
2017-01-08T02:19:13.168315Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-01-08T02:19:13.169315Z 0 [Note] Shutting down plugin 'MEMORY'
2017-01-08T02:19:13.169315Z 0 [Note] Shutting down plugin 'CSV'
2017-01-08T02:19:13.170315Z 0 [Note] Shutting down plugin 'sha256_password'
2017-01-08T02:19:13.170315Z 0 [Note] Shutting down plugin 'mysql_native_password'
2017-01-08T02:19:13.171315Z 0 [Note] Shutting down plugin 'binlog'
2017-01-08T02:19:13.172316Z 0 [Note] mysqld: Shutdown complete
###補足情報(言語/FW/ツール等のバージョンなど)
・Mysqlは、以下のページの「Windows (x86, 64-bit), ZIP Archive」を選択しています。
https://dev.mysql.com/downloads/mysql/
回答1件
あなたの回答
tips
プレビュー