C:\Users\Happy>mysqld --console 2014-05-02 09:46:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca ted. Please use --explicit_defaults_for_timestamp server option (see documentati on for more details). 2014-05-02 09:46:29 6512 [Note] Plugin 'FEDERATED' is disabled. 2014-05-02 09:46:29 6512 [Note] InnoDB: The InnoDB memory heap is disabled 2014-05-02 09:46:29 6512 [Note] InnoDB: Mutexes and rw_locks use Windows interlo cked functions 2014-05-02 09:46:29 6512 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-05-02 09:46:29 6512 [Note] InnoDB: Not using CPU crc32 instructions 2014-05-02 09:46:29 6512 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-05-02 09:46:29 6512 [Note] InnoDB: Completed initialization of buffer pool 2014-05-02 09:46:29 6512 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode 2014-05-02 09:46:29 6512 [ERROR] InnoDB: The system tablespace must be writable! 2014-05-02 09:46:29 6512 [ERROR] Plugin 'InnoDB' init function returned error. 2014-05-02 09:46:29 6512 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN E failed. 2014-05-02 09:46:29 6512 [ERROR] mysqld: unknown variable 'default-character-set =utf8' 2014-05-02 09:46:29 6512 [ERROR] Aborting 2014-05-02 09:46:29 6512 [Note] Binlog end 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'partition' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD ' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_METRICS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET ' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_CMP' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'INNODB_TRX' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'BLACKHOLE' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'ARCHIVE' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'MRG_MYISAM' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'MyISAM' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'MEMORY' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'CSV' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'sha256_password' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'mysql_old_password' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'mysql_native_password' 2014-05-02 09:46:29 6512 [Note] Shutting down plugin 'binlog' 2014-05-02 09:46:29 6512 [Note] mysqld: Shutdown complete
错误原因一般是由:my.ini配置属性错误引起的,修改正确的配置文件内容。
例如:5.6这样配置是错误的:default-character-set=utf8
正确的配置:default_character_set=utf8
最小化配置:
# Save as "my.ini" in your MySQL installed directory [mysqld] # Set MySQL base (installed) directory # @@ Change to your MySQL installed directory @@ basedir = D:Database/mysql-5.6.14-winx64 # Set MySQL data directory # @@ Change to sub-directory "data" of your MySQL installed directory @@ datadir = D:/Database/mysql-5.6.14-winx64/data # Run the server on this TCP port number port = 2222 [client] # MySQL client connects to the server running on this TCP port number port = 2222
相关推荐
Installing MySQL system tables...2015-08-13 14:20:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for ...
Installing MySQL system tables...2015-08-13 14:20:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for ...
下面给大家介绍下MySQL5.7.16绿色版安装教程,具体内容如下所示: 如图所示: ...2016-10-16T21:45:48.466872Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
directive because it is not set or is mistyped, a default value will be used. ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one ; of the INI constants (On, Off, True, ...
2017-06-05T14:30:52.709474Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-06-05...
Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor ...
Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor ...
Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor ...
Clicking on an item will show the text with syntax highlighting in the preview pane, and will show the timestamp above the preview pane. Double-click on an item to paste the text in the cursor ...