Check if translate5 runs with latest MariaDB and MySQL versions

Please verify if translate5 runs smoothly on the latest versions of MySQL and MariaDB.

Please do this by installing them on your system, importing your translate5 DB into them and running our tests on the translate5 instance.

Please also check, if there are changes with the new DB versions regarding the database flags that need to be set (see installation manual).

Running all testcases on these versions should do it?

Setting up translate5 with MySQL 8 in a docker container

# run docker
docker run --name mysql8-test -e MYSQL_ROOT_PASSWORD=foo123 -e TZ=Europe/Berlin --volume=/tmp/docker/conf.d:/etc/mysql/conf.d -d mysql:8

# call mysql command in container
docker exec -it mysql8-test mysql -uroot -p

# create a tmp conf.d with a docker.cnf: 
[mysqld]
skip-host-cache
skip-name-resolve
log_bin_trust_function_creators = 1
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

# and a mysql.cnf
[mysql]

# create translate5 database: 
  CREATE DATABASE IF NOT EXISTS `translate5` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  CREATE USER 'translate5'@'%' IDENTIFIED BY 'foo123';
  GRANT ALL ON translate5.* TO 'translate5'@'%';

# install translate5
mkdir translate5
cd translate5
wget https://downloads.translate5.net/translate5.zip
unzip translate5.zip

# connect to mysql8:
mysql -h 172.17.0.2 -u translate5 -pfoo123 translate5

Translate5 installation and start up

Fixes in DbInit.sql:

• remove all set_mode NO_AUTO_CREATE_USER
  → DbInit.sql should be rebuild completely new without NO_AUTO_CREATE_USER
  → Is that DbInit.sql then compatibel with older MySQL AND MySQL 8?

• Finally translate5 could not be started due syntax errors in some alter files (not compatible SQL Syntax with MySQL 8)

Fixes in Documentation:

• preferred sql mode (remove NO_AUTO_CREATE_USER here too):
  sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"