[Koha-bugs] [Bug 17258] [OMIBUS] MySQL 5.7

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258

--- Comment #6 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Jonathan Druart from comment #5)
> See
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.
> 04_and_MySQL_5.7

On Ubuntu 16.04 (and others recent distro) now (Nov. 2016) is present MySQL
5.7. All version of Koha (3.x, 16.05, 16.11) are not compatible with default
config of MySQL 5.7. To bypasss the problem you can:

    Install MariaDB instead of MySQL [ sudo apt-get install mariadb-server]
    OR Insert in your /etc/mysql/my.conf: 

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

After save the changes and restart mysql.

-- 
You are receiving this mail because:
You are watching all bug changes.