What do I have to consider from MySQL 5.7 and MariaDB 10.2?
As of version 4.1.0 ViMP is compatible with MySQL 5.7 and MariaDB 10.2, provided the following setting is set in the [mysqld] section of your mysql configuration file (e.g. my.cnf):
sql_mode = IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO
Until further notice, this setting is also valid for MySQL 8 and MariaDB >10.2, which are supported since ViMP 4.2.10.
Restart MySQL or MariaDB after the change.
Please also note that as of MySQL 8, database users can no longer be created (implicitly) with the GRANT command. Instead, use CREATE USER followed by the GRANT statement:
mysql> CREATE USER 'DATABASEUSER'@'localhost' IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'DATABASEUSER'@'localhost' WITH GRANT OPTION;
Last update on 2021/04/29 by Admin.