apt update && apt upgrade -y

apt install ca-certificates apt-transport-https lsb-release curl nano unzip -y

wget -q https://packages.sury.org/php/apt.gpg -O- | apt-key add -

echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" | tee /etc/apt/sources.list.d/php.list

apt update

apt install apache2 php7.4 php7.4-cli php7.4-curl php7.4-gd php7.4-intl php7.4-json php7.4-mbstring php7.4-mysql php7.4-opcache php7.4-readline php7.4-xml php7.4-xsl php7.4-zip php7.4-bz2 libapache2-mod-php7.4 -y

apt install mariadb-server mariadb-client -y

mysql -u root

UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';

FLUSH PRIVILEGES;

exit;

mysql -u root -p

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

exit;

cd /usr/share && wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip -O phpmyadmin.zip

unzip phpmyadmin.zip && rm phpmyadmin.zip

mv phpMyAdmin-*-all-languages phpmyadmin

mkdir /usr/share/phpmyadmin/tmp/ && chown -R www-data:www-data /usr/share/phpmyadmin/tmp/

chmod -R 0755 phpmyadmin && nano /etc/apache2/conf-available/phpmyadmin.conf

#Einfügen > STRG + X > y > ENTER
Alias /phpmyadmin /usr/share/phpmyadmin
<Directory /usr/share/phpmyadmin>
Options SymLinksIfOwnerMatch
DirectoryIndex index.php
</Directory>

# Disallow web access to directories that don't need it
<Directory /usr/share/phpmyadmin/templates>
Require all denied
</Directory>

<Directory /usr/share/phpmyadmin/libraries>
Require all denied
</Directory>

<Directory /usr/share/phpmyadmin/setup/lib>
Require all denied
</Directory>

a2enconf phpmyadmin && systemctl reload apache2