Page History

...

sudo apt-get install mysql-server mysql-client

The installation process will prompt a few times for a new root password access for MySQL. Please provide a password, when prompted. Please ensure you type the same password every time. If you omit a password you could get problems with a MySQL version greater 5.7, in this case follow the instructions in: http://askubuntu.com/a/801950/428011
You can test the reachability of the database by issuing at a terminal:

...

In general you will find the mysql configuration in "/etc/mysql/mysql.conf.d/mysqld.cnf" or in "/etc/mysql/my.cnf" or a similar file.

Charset and Collation

The charset is set on creation of the concrete DB in the next step.

Full text index optimization

For proper functionality of the termportal search the minimum index token length must be set to 1:

innodb_ft_min_token_size=1
After changing this values the indexes must be rebuild:

Rebuild the index if you just changed some of the above settings:

set GLOBAL innodb_optimize_fulltext_only=ON;
OPTIMIZE TABLE terms_term;

On MySQL 5.7 the innodb_optimize_fulltext_only flag should be kept disabled, since there the rebuild of the index does not properly work!

Timezone

Ensure that the timezone of MySQL is the same as the timezone configured in apache php and CLI php.

To get the MySQLs timezone call:

SELECT @@global.time_zone, @@session.time_zone;
-- or more easier to read:
SELECT TIME_FORMAT(TIMEDIFF(utc_timestamp(), NOW()), '%H:%i') gmtshift;

Not allowed SQL Modes

The following SQL Mode must not be set: ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE, STRICT_TRANS_TABLES

...

sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

For MySQL 8 this would be: 
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

See http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html for further information.

...

/etc/init.d/mysql restart

Install PHP

...

8.

...

0 core

Please refresh your package list, the package names may be different, but it must be at least PHP 8.0.X at the moment.

sudo apt-get update

and install php 78.30

sudo apt-get install php7php8.30

Check if you have the correct version of php installed

...

sudo apt-get install libapache2-mod-php7php8.30 php7php8.30-mysql php7php8.30-gd php7php8.30-dom php7php8.30-mbstring php7php8.30-zip php7php8.30-curl php7php8.30-intl php7php8.30-json

• dom
• fileinfo
• gd with Freetype-Support
• iconv
• mbstring
• pdo_mysql
• zip
• curl
• xml
• intl
• json
• opcache
• soap
• sqlite3

...

sudo apt install openjdk-8-jdk

Install unzip

sudo apt-get install unzip