...
sudo apt-get install mysql-server mysql-client
Warning |
---|
MySQL 8.X does not work currently |
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:
...
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:
Code Block | ||
---|---|---|
| ||
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.
...
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
...