blocks|key|3028536|text|首先，您还不需要更改任何内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028537|3028538|这些非标准行为仍然是时间戳的缺省行为，但从MySQL+5.6.6开始，这些非标准行为将被弃用，并且在启动时会出现此警告|blockquote|3028539|3028540|3028541|现在，如果你想移动到new+behaviors，你必须在你的my.cnf中的mysqld部分添加这一行。|offset|length|style|CODE|3028542|explicit_defaults_for_timestamp+=+1|code-block|syntax|javascript|3028543|my.cnf+(或其他配置文件)的位置因系统而异。如果找不到，请参考https://dev.mysql.com/doc/refman/5.7/en/option-files.html|3028544|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp|1|https://dev.mysql.com/doc/refman/5.7/en/option-files.html^0|0|0|0|0|0|U|6|A|D|0|0|0|Y|1L|1|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|19|8|@$J|1A|K|1B|L|M]]|9|@$J|1C|K|1D|1|1E]]|A|$]]|$1|N|3|O|5|P|7|1F|8|@]|9|@]|A|$Q|R]]|$1|S|3|T|5|6|7|1G|8|@]|9|@$J|1H|K|1I|1|1J]]|A|$]]|$1|U|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|X|Y|Z|A|$10|13]]]]

First you don't need to change anything yet.

<blockquote>
 Those nonstandard behaviors remain the default for TIMESTAMP but as of
 MySQL 5.6.6 are deprecated and this warning appears at startup
</blockquote>

Now if you want to move to <a href="https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp" rel="noreferrer">new behaviors</a> you have to add this line in your <code>my.cnf</code> in the [mysqld] section.

<pre><code>explicit_defaults_for_timestamp = 1
</code></pre>

The location of my.cnf (or other config files) vary from one system to another. If you can't find it refer to <a href="https://dev.mysql.com/doc/refman/5.7/en/option-files.html" rel="noreferrer">https://dev.mysql.com/doc/refman/5.7/en/option-files.html</a>

blocks|key|3028604|text|在Windows平台上，|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3028605|3028606|找到您的my.ini配置文件。|ordered-list-item|3028607|在my.ini中转到[mysqld]部分。|CODE|3028608|添加不带引号的explicit_defaults_for_timestamp=true并保存change.|3028609|Start+mysqld|3028610|3028611|这对我很有效(Windows7旗舰版32位)|3028612|entityMap^0|1|7|0|0|4|6|0|1|6|A|8|0|7|10|7|10|0|6|6|0|0|7|E|0^^$0|@$1|2|3|4|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|J|3|K|5|I|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|L]]|D|@]|E|$]]|$1|M|3|N|5|I|7|17|8|@$9|18|A|19|B|C]|$9|1A|A|1B|B|L]]|D|@]|E|$]]|$1|O|3|P|5|I|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|1F|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|1G|8|@$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]]|U|$]]

On a Windows platform,
<ol>
<li>Find your my.ini configuration file.</li>
<li>In my.ini go to the <code>[mysqld]</code> section.</li>
<li>Add <code>explicit_defaults_for_timestamp=true</code> without quotes and save the change.</li>
<li>Start mysqld</li>
</ol>
This worked for me (windows 7 Ultimate 32bit)

blocks|key|192852|text|我使用的是Windows+8.1，并使用以下命令|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192853|c:\wamp\bin\mysql\mysql5.6.12\bin\mysql.exe|code-block|syntax|javascript|192854|而不是|192855|+c:\wamp\bin\mysql\mysql5.6.12\bin\mysqld|192856|它工作得很好..|192857|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I'm Using Windows 8.1 and I use this command

<pre><code>c:\wamp\bin\mysql\mysql5.6.12\bin\mysql.exe
</code></pre>

instead of

<pre><code> c:\wamp\bin\mysql\mysql5.6.12\bin\mysqld
</code></pre>

and it works fine..

blocks|key|190773|text|在我的系统(Windows8.1)上，问题出在服务器配置上。服务器在我安装的时候第一次就能工作了。但是，我忘了勾选"run+as+a+service“选项，这导致了所有的问题。我在SO上尝试了所有可能的解决方案，但都不起作用。因此，我决定重新安装MySQL工作台。在执行我之前用于安装MySQL工作台的同一个msi文件时，我重新配置了服务器，并允许将服务器作为服务运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|190774|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

On my system (Windows 8.1), the problem was with the server configuration. The server worked for the first time when I installed it. However, I forgot to check the "run as a service" option and this caused all the problem. I tried all possible solutions available on SO but nothing worked. So, I decided to reinstall MySQL Workbench. On executing the same msi file that I earlier used to install MySQL workbench, I reconfigured the server and allowed to run the server as a service.

blocks|key|3028681|text|在Windows上，您可以使用option键运行服务器，无需更改ini文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028682|"C:\mysql\bin\mysqld.exe"+--explicit_defaults_for_timestamp=1|offset|length|style|CODE|3028683|entityMap^0|0|0|1P|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

On Windows you can run server with option key, no need to change ini files.

<code>"C:\mysql\bin\mysqld.exe" --explicit_defaults_for_timestamp=1</code>

blocks|key|194986|text|在Windows上--打开位于"C:\ProgramData\MySQL\MySQL+Server5.6“的my.ini文件，在下一行中找到"mysqld”(不带引号)添加explicit_defaults_for_timestamp，然后保存更改。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194987|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

On Windows -- open my.ini file, present at "C:\ProgramData\MySQL\MySQL Server 5.6", find "[mysqld]" (without quotes) in next line add explicit_defaults_for_timestamp and then save the changes.

blocks|key|3028737|text|在mysql命令行中：SET+explicit_defaults_for_timestamp=1|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3028738|entityMap^0|B|11|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

In your mysql command line: <code>SET explicit_defaults_for_timestamp=1</code>

blocks|key|190813|text|对我来说，将短语"explicit_defaults_for_timestamp+=+ON"“不带引号添加到配置文件my.ini中是可行的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|190814|确保将此短语添加到配置文件中mysqld语句的正下方。|190815|如果您执行了MySQL的默认安装，您将在C:\ProgramData\MySQL\MySQL+Server+5.7下找到my.ini。|190816|entityMap^0|8|12|1M|6|0|0|K|11|1O|6|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|D]]|E|@]|F|$]]|$1|G|3|H|5|6|7|R|8|@]|E|@]|F|$]]|$1|I|3|J|5|6|7|S|8|@$9|T|A|U|B|D]|$9|V|A|W|B|D]]|E|@]|F|$]]|$1|K|3|-4|5|6|7|X|8|@]|E|@]|F|$]]]|L|$]]

For me it worked to add the phrase "explicit_defaults_for_timestamp = ON" without quotes into the config file <code>my.ini</code>. 

Make sure you add this phrase right underneath the [mysqld] statement in the config file. 

You will find <code>my.ini</code> under <code>C:\ProgramData\MySQL\MySQL Server 5.7</code> if you had conducted the default installation of MySQL.

blocks|key|2816311|text|在mysql命令行中执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2816312|mysql>+SHOW+GLOBAL+VARIABLES+LIKE+'%25timestamp%25';
%2B---------------------------------%2B-------%2B
%7C+Variable_name+++++++++++++++++++%7C+Value+%7C
%2B---------------------------------%2B-------%2B
%7C+explicit_defaults_for_timestamp+%7C+OFF+++%7C
%7C+log_timestamps++++++++++++++++++%7C+UTC+++%7C
%2B---------------------------------%2B-------%2B
2+rows+in+set+(0.01+sec)

mysql>+SET+GLOBAL+explicit_defaults_for_timestamp+=+1;
Query+OK,+0+rows+affected+(0.00+sec)

mysql>+SHOW+GLOBAL+VARIABLES+LIKE+'%25timestamp%25';
%2B---------------------------------%2B-------%2B
%7C+Variable_name+++++++++++++++++++%7C+Value+%7C
%2B---------------------------------%2B-------%2B
%7C+explicit_defaults_for_timestamp+%7C+ON++++%7C
%7C+log_timestamps++++++++++++++++++%7C+UTC+++%7C
%2B---------------------------------%2B-------%2B
2+rows+in+set+(0.00+sec)|code-block|syntax|javascript|2816313|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In your mysql command line do the following:

<pre class="lang-sql prettyprint-override"><code>mysql&gt; SHOW GLOBAL VARIABLES LIKE '%timestamp%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| explicit_defaults_for_timestamp | OFF |
| log_timestamps | UTC |
+---------------------------------+-------+
2 rows in set (0.01 sec)

mysql&gt; SET GLOBAL explicit_defaults_for_timestamp = 1;
Query OK, 0 rows affected (0.00 sec)

mysql&gt; SHOW GLOBAL VARIABLES LIKE '%timestamp%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| explicit_defaults_for_timestamp | ON |
| log_timestamps | UTC |
+---------------------------------+-------+
2 rows in set (0.00 sec)
</code></pre>

When I try to start my mySQL server I get message:

<blockquote>
 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
 Please use --explicit_defaults_for_timestamp server option (see
 documentation for more details).
</blockquote>

I find answer on: 
<a href="http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp" rel="noreferrer">http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp</a>

But how to enable it? Where?

How to enable explicit_defaults_for_timestamp?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当我尝试启动mySQL服务器时，收到消息：带有隐式默认值的警告时间戳是使用--explicit_defaults_  _ TIMESTAMP服务器选项(有关更多详细信息，请参阅文档)。我的答案是：但是如何启用它呢？哪里?

问如何启用explicit_defaults_for_timestamp？
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何启用explicit_defaults_for_timestamp？EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何启用explicit_defaults_for_timestamp？
EN