TIMESTAMP with implicit DEFAULT value is depreca
我是在官网上下在的MySQL数据库,[mysql-5.6.12-winx64.zip],解压之后,把“my-default.ini”文件修改为my.ini文件进行修改参数: ************************************** basedir = D:/Program Files/mysql-5.6.12-winx64 datadir = D:/Program Files/mysql-5.6.12-winx64/data port = 3306 server_id = 1 ************************************** 修改完后保存,使用cmd命令行进行输入:—————————————————————————————————— D:\Program Files\mysql-5.6.12-winx64\bin>mysqld -install MySQL -defualts-file=D: \Program Files\mysql-5.6.12-winx64\my.ini —————————————————————————————————— 结果显示:------------------------------------------------------------ 2013-07-04 22:27:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca ted. Please use --explicit_defaults_for_timestamp server option (see documentati on for more details). ------------------------------------------------------------ 在日志中显示的为: ----------------------------------------------------------- 2013-07-04 22:43:22 41024 [Note] Plugin 'FEDERATED' is disabled. 2013-07-04 22:43:22 41024 [Note] InnoDB: The InnoDB memory heap is disabled 2013-07-04 22:43:22 41024 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2013-07-04 22:43:22 41024 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-07-04 22:43:22 41024 [Note] InnoDB: Not using CPU crc32 instructions 2013-07-04 22:43:22 41024 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2013-07-04 22:43:22 41024 [Note] InnoDB: Completed initialization of buffer pool 2013-07-04 22:43:22 41024 [Note] InnoDB: Highest supported file format is Barracuda. 2013-07-04 22:43:22 41024 [Note] InnoDB: 128 rollback segment(s) are active. 2013-07-04 22:43:22 41024 [Note] InnoDB: Waiting for purge to start 2013-07-04 22:43:22 41024 [Note] InnoDB: 5.6.12 started; log sequence number 1626097 2013-07-04 22:43:22 41024 [ERROR] mysqld: unknown option '-i' 2013-07-04 22:43:22 41024 [ERROR] Aborting 检查一下my.ini中有无 '-i'的选项
mysqld --defaults-file="D:\Program Files\mysql-5.6.12-winx64\my.ini"
试一下。
注意单词拼写 --defaults-file=file_name
|