This worked for me on version 18.1 Serena Xfce
Install Apache
sudo apt-get install apache2
Verify: open browser with URL http://localhost/
Install PHP 7
sudo apt-get install php libapache2-mod-php
Create test file
sudo vi /var/www/html/phpinfo.php
content:
<?php phpinfo(); ?>
Now point your browser to http://localhost/phpinfo.php
Install MySQL & phpMyAdmin
sudo apt-get install mysql-server php-mysql phpmyadmin
Verify: open browser with URL http://localhost/phpmyadmin/
Bonus: Connect LibreOffice to MySQL
Install connector:
sudo apt-get install libreoffice-mysql-connector
Open LibreOffice Base - the database wizard shows
Connect to an existing database, select MySQL
Connect directly
Enter database server data
Setup user authentication & test connection (use credentials entered when installing)
Save ODB file & proceed, you should be able to see the list of tables and operate normally with the database.