apt-get install apache2
apt-get install mariadb-server
mysql_secure_installation
Change the root password? [Y/n] n
Remove anonymous users? [Y/n] y
Disallow root login remotely? [Y/n] y
Remove test database and access to it? [Y/n] y
Reload privilege tables now? [Y/n] y
mariadb
grant all privileges on *.* to 'root'@'localhost' identified by '<password_root_mysql>';
apt-get install php libapache2-mod-php php-mysql
apt-get install php-mbstring php-zip php-gd
apt-get install php-imagick php-phpseclib php-php-gettext php7.3-common php7.3-mysql php7.3-gd php7.3-imap php7.3-json php7.3-curl php7.3-zip php7.3-xml php7.3-mbstring php7.3-bz2 php7.3-intl php7.3-gmp
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.2/phpMyAdmin-5.0.2-english.tar.gz
tar xvf phpMyAdmin-5.0.2-english.tar.gz
mkdir /var/www/sites/
mv phpMyAdmin-5.0.2-english/ /var/www/sites/phpmyadmin
chown -R www-data:www-data /var/www/sites/phpmyadmin
nano /etc/apache2/conf-available/phpmyadmin.conf
Alias /pma /var/www/sites/phpmyadmin
<Directory /var/www/sites/phpmyadmin>
Options FollowSymLinks
DirectoryIndex index.php
AllowOverride All
</Directory>
<Directory /var/www/sites/phpmyadmin/templates>
Require all denied
</Directory>
<Directory /var/www/sites/phpmyadmin/libraries>
Require all denied
</Directory>
<Directory /var/www/sites/phpmyadmin/setup/lib>
Require all denied
</Directory>
nano /var/www/sites/phpmyadmin/.htaccess
AuthType Basic
AuthName "Restricted Files"
AuthUserFile /var/www/sites/phpmyadmin/.htpasswd
Require valid-user
htpasswd -c /var/www/sites/phpmyadmin/.htpasswd <phpmyadmin_username>
a2enconf phpmyadmin
service apache2 restart
Telah Terbit