2014.9.25
本想在MySQL上面做点实验的,可以登录的时候报错(ps:mysql 服务已经是开启的):
window 7 64位,
MySQL 5.7
![[Warning] TIMESTAMP with implicit DEFAULT --explicit_defaults_for_timestamp](/upload/otherpic71/24594.jpg)
日志:
点击(此处)折叠或打开
创新互联是一家专注于网站制作、网站建设与策划设计,四子王网站建设哪家好?创新互联做网站,专注于网站建设十年,网设计领域的专业建站公司;建站业务涵盖:四子王等地区。四子王做网站价格咨询:028-86922220
-
2014-09-25T04:19:53.971570Z 0 [Note] Plugin \'FEDERATED\' is disabled.
-
2014-09-25T04:19:53.974570Z 0 [Warning] InnoDB: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB\'s internal memory allocator.
-
2014-09-25T04:19:53.977570Z 0 [Note] InnoDB: The InnoDB memory heap is disabled
-
2014-09-25T04:19:53.978570Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
-
2014-09-25T04:19:53.979570Z 0 [Note] InnoDB: Uses system mutexes
-
2014-09-25T04:19:53.980570Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
-
2014-09-25T04:19:53.982571Z 0 [Warning] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
-
2014-09-25T04:19:53.987571Z 0 [Note] InnoDB: Number of pools: 1
-
2014-09-25T04:19:53.988571Z 0 [Note] InnoDB: Not using CPU crc32 instructions
-
2014-09-25T04:19:54.003572Z 0 [Note] InnoDB: Initializing buffer pool, total size = 57.0M, instances = 1
-
2014-09-25T04:19:54.012572Z 0 [Note] InnoDB: Completed initialization of buffer pool
-
2014-09-25T04:19:54.016573Z 0 [ERROR] InnoDB: .\\ibdata1 must be writable
-
2014-09-25T04:19:54.017573Z 0 [ERROR] InnoDB: The system tablespace must be writable
-
2014-09-25T04:19:54.218584Z 0 [ERROR] Plugin \'InnoDB\' init function returned error.
-
2014-09-25T04:19:54.219584Z 0 [ERROR] Plugin \'InnoDB\' registration as a STORAGE ENGINE failed.
-
2014-09-25T04:19:54.220584Z 0 [ERROR] mysqld: unknown option \'-p\'
-
2014-09-25T04:19:54.221584Z 0 [ERROR] Aborting
-
-
2014-09-25T04:19:54.222584Z 0 [Note] Binlog end
-
2014-09-25T04:19:54.223584Z 0 [Note] Shutting down plugin \'partition\'
-
2014-09-25T04:19:54.224584Z 0 [Note] Shutting down plugin \'PERFORMANCE_SCHEMA\'
-
2014-09-25T04:19:54.225584Z 0 [Note] Shutting down plugin \'INNODB_SYS_DATAFILES\'
-
2014-09-25T04:19:54.227585Z 0 [Note] Shutting down plugin \'INNODB_SYS_TABLESPACES\'
-
2014-09-25T04:19:54.228585Z 0 [Note] Shutting down plugin \'INNODB_SYS_FOREIGN_COLS\
但是奇怪的是,这是在cmd下面报错。我用Navicat for Mysql 连接到MySQL,是可以正常连接的。
网上找了很多文章,有以下几种解决方案,可能适合你的情况:
1、删除data目录下的ib_logfile0和ib_logfile1文件,重启MySQL。
-----这种多发生在启动MySQL服务时,不能开启MySQL服务。但是我的服务可以正常的开启和关闭:
2、在my.ini mysqld 下添加 explicit_defaults_for_timestamp=true
-----我添加之后,还是原来的错误。
3、手动的在服务里面,重启MySQL服务
-----这种可能性表示怀疑。手动的跟命令行下,应该都一样吧
中午吃饭回来继续解决。
可发现,报错不一样了
![[Warning] TIMESTAMP with implicit DEFAULT --explicit_defaults_for_timestamp](/upload/otherpic71/24595.jpg)
然后又把添加的参数给注释掉。
再登录的时候,居然可以登录了。
真的百思不得其解。刚刚接触MySQL,很多问题不会,只能通过度娘以及认识的大牛们。
哈哈 现在要下班了,刚刚在Linux环境下同样遇见这个问题:
-
[root@BIDEVEDW_DB bin]# ./mysqld -uroot -p
-
2014-09-25 17:29:05 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
-
2014-09-25 17:29:05 24368 [Note] Plugin \'FEDERATED\' is disabled.
-
2014-09-25 17:29:05 24368 [Note] InnoDB: Using atomics to ref count buffer pool pages
-
2014-09-25 17:29:05 24368 [Note] InnoDB: The InnoDB memory heap is disabled
-
2014-09-25 17:29:05 24368 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
-
2014-09-25 17:29:05 24368 [Note] InnoDB: Compressed tables use zlib 1.2.3
-
2014-09-25 17:29:05 24368 [Note] InnoDB: Using Linux native AIO
-
2014-09-25 17:29:05 24368 [Note] InnoDB: Using CPU crc32 instructions
-
2014-09-25 17:29:05 24368 [Note] InnoDB: Initializing buffer pool, size = 9.0G
-
2014-09-25 17:29:07 24368 [Note] InnoDB: Completed initialization of buffer pool
-
2014-09-25 17:29:08 24368 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
-
2014-09-25 17:29:08 24368 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
但是这样就可以登录了:
-
[root@BIDEVEDW_DB bin]# ./mysql -uroot -p
-
Enter password:
-
Welcome to the MySQL monitor. Commands end with ; or \\g.
-
Your MySQL connection id is 19445
-
Server version: 5.6.19 Source distribution
-
-
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
-
-
Oracle is a registered trademark of Oracle Corporation and/or its
-
affiliates. Other names may be trademarks of their respective
-
owners.
-
-
Type \'help;\' or \'\\h\' for help. Type \'\\c\' to clear the current input statement.
-
-
mysql>
度娘还是那些,这次请教大牛。这是与大牛的对话:
![[Warning] TIMESTAMP with implicit DEFAULT --explicit_defaults_for_timestamp](/upload/otherpic71/24596.jpg)
![[Warning] TIMESTAMP with implicit DEFAULT --explicit_defaults_for_timestamp](/upload/otherpic71/24597.jpg)
总算明白是怎么会事儿了!
回家!
当前名称:[Warning]TIMESTAMPwithimplicitDEFAULT--explicit_defaults_for_timestamp
当前网址:
http://bjjierui.cn/article/pspige.html