我很难让它工作我已经测试过它并且它在灯服务器 mysql 版本 5.12 上工作

I had a struggle getting this to work i've tested it and it's working on lamp server mysql version 5.12

那么，成功的步骤:

1. sudo vim/etc/mysql/conf.d/mysql.cnf

2. 滚动到文件底部复制粘贴

1. sudo vim /etc/mysql/conf.d/mysql.cnf

2. Scroll to the bottom of file Copy and paste

[mysqld]sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

到文件底部

1. 保存并退出输入模式
2. sudo service mysql restart 重启 MySQL.

1. save and exit input mode
2. sudo service mysql restart to restart MySQL.

完成！