关于mysql 出现 1264 Out of range value for column 错误的解决办法

vi /usr/local/mysql/my.cnf

修改sql-mode为

sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

重启mysql

[root@localhost mysql]# service mysqld restart
mysqld: unrecognized service
[root@localhost mysql]# service mysql restart
Shutting down MySQL... SUCCESS!