Troubleshooting Apache, PHP 7.0, and MariaDB LAMP, LAMP is an acronym that stands for Linux Apache, MySQL/MariaDB and PHP. I have LAMP installation post for PiHome but i see lots and lots of people are looking for setting up php 7 with phpMyAdmin and MariaDB on raspberry pi and there isn’t any comprehensive set of instruction that covers this all for PHP 7, MariaDB on raspberry pi.

If you are installing LAMP on your Raspberry Pi for PiHome you can refer to this post as php 7 isn’t supported yet. Follow OS (Raspbian Jessie) Installation and WiFi Configuration posts to install and get WiFi configured without any screen connected to Raspberry pi.

In this post i will discuss common issues with php 7, MariaDB and phpmyadmin on raspberry pi. Follow this link to Install Apache, PHP 7.0 and MySQL/MariaDB on a Raspberry Pi (LAMP) with phpMyAdmin on Raspberry Pi.

Missing PhpMyAdmin User and Database Tab

phpMyAdmin main screen no “User Tab” and Under “Database Tab” Create Database – “No Privileges ” . What can I do to Get the “User Tab” and Privileges, run following command and follow the on screen steps.

This will fix your issue,

You may need to check phpmyadmin.config files as well for MySQL/MariaDB username and password. and make sure you have correct mysql/mariadb credentials.


Note: i m working on SD card image with Rasbian,  PHP 7.0 and MySQL/MariaDB on a Raspberry Pi (LAMP) with phpMyAdmin but i m waiting for 8gb sd card delivery. let me know if you want to include anything in this image.

gpg: no valid OpenPGP data found.

If you get Error message for gpg: no valid OpenPGP data found.

Make sure you edit your /etc/apt/sources.list file and it should look like

E: Package ‘mariadb-server’ has no installation candidate E: Unable to locate package mariadb-client

If you get this error message while installing MariaDB, You have to determine which version of raspbian you have installed.

After figuring out which version choose the one for jessie or the one for stretch. Make sure you choose the correct repository for the version of raspbian. (Thanks to Jonathan)

If you are looking for Raspberry pi SD card image for LAMP (Apache, PHP 7.0 and MySQL/MariaDB on a Raspberry Pi with phpMyAdmin) pre installed then check out Download section.