I've just installed 16.04 server in a VM, updated, then installed mysql-server mysql-client. I ran the command request by Paul as the root user. I also cleaned up the output.
@@global.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
@@session.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
@@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
I've just installed 16.04 server in a VM, updated, then installed mysql-server mysql-client.
I ran the command request by Paul as the root user. I also cleaned up the output.
@@global.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
@@session.sql_mode = GROUP_BY, STRICT_ TRANS_TABLES, NO_ZERO_ IN_DATE, NO_ZERO_ DATE,ERROR_ FOR_DIVISION_ BY_ZERO, NO_AUTO_ CREATE_ USER,NO_ ENGINE_ SUBSTITUTION
ONLY_FULL_
@@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