centos安装mysql遇到的小bug

问题1：

2017-02-22T17:52:21.080007Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

其原因是从 5.6开始，timestamp 的默认行为已经是 deprecated 了。
http://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html
解决方案：

vi /etc/my.cnf

后面添加一行：
explicit_defaults_for_timestamp=1

问题2：

mysqld: Can't create/write to file '/tmp/ibI4Is7u' (Errcode: 13 - Permission denied)
2017-02-22T18:03:42.361290Z 0 [ERROR] InnoDB: Unable to create temporary file; errno: 13
2017-02-22T18:03:42.361309Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-02-22T18:03:42.361320Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-02-22T18:03:42.361326Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-02-22T18:03:42.361332Z 0 [ERROR] Failed to initialize plugins.
2017-02-22T18:03:42.361337Z 0 [ERROR] Aborting

解决方案：

修改tmp目录权限为777

chmod 777 -R /tmp/