show variables like 'sql_mode';
This showed the following:
sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
The problem is two of those in the middle, specifically, NO_ZERO_IN_DATE and NO_ZERO_DATE. I'm not sure what the others do but in deference to the builders of MySQL that put them in there by default I decided to leave the rest in there but remove those two. In order to do that I changed the my.cnf file (on my system /etc/mysql/my.cnf) and added the following line after the [mysqld] header:sql-mode="STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
After restarting the mysql server (sudo service mysql restart) when I ran the "show variables" query in MySQL it showed the proper values (i.e. missing the two problematic ones). For the record, the MySQL version is 5.7.25 and I started at 5.5.62.