{"id":699,"date":"2018-03-05T14:02:23","date_gmt":"2018-03-05T06:02:23","guid":{"rendered":"https:\/\/www.techcoil.com\/blog\/?p=699"},"modified":"2018-08-10T11:12:11","modified_gmt":"2018-08-10T03:12:11","slug":"how-to-setup-phpmyadmin-on-a-raspbian-stretch-lite-nginx-mariadb-mysql-and-php-7-lemp-stack","status":"publish","type":"post","link":"https:\/\/www.techcoil.com\/blog\/how-to-setup-phpmyadmin-on-a-raspbian-stretch-lite-nginx-mariadb-mysql-and-php-7-lemp-stack\/","title":{"rendered":"How to setup phpMyAdmin on a Raspbian Stretch Lite, Nginx, MariaDB \/ MySQL and PHP 7 LEMP stack"},"content":{"rendered":"

The phpMyAdmin<\/a> project is a solid software tool written in PHP, that can help us handle the administration of MySQL \/ MariaDB over the web. <\/p>\n

\"phpMyAdmin<\/p>\n

If you want to build your next project with a Raspbian Stretch Lite, Nginx, MariaDB \/ MySQL and PHP 7 LEMP stack<\/a>, you may want to consider setting up phpMyAdmin as well. This post details how you can do so.<\/p>\n

Prerequisites<\/h2>\n

This post assumes that you had setup a Raspberry Pi running a Raspbian Stretch Lite, Nginx, MariaDB \/ MySQL and PHP 7 LEMP stack<\/a>. If you had not done so, you may want to reference either the Raspberry Pi 3 WordPress<\/a> tutorial or Raspberry Pi Zero W WordPress<\/a> tutorial to setup your LEMP stack.<\/p>\n

Using SSH to get into your Raspbian Stretch Lite<\/h2>\n

Suppose that your Raspbian Stretch Lite had gotten the IP address 192.168.1.109<\/code> from your home router and you had the pi<\/code> user in the system, run the following command on your terminal to SSH into your Raspberry Stretch Lite:<\/p>\n

\r\nssh pi@192.168.1.109\r\n<\/pre>\n
Installing mbstring extension for PHP 7.0 on Raspbian Stretch Lite<\/h2>\n
Without the mbstring<\/code><\/a> extension, phpMyAdmin is unable to split strings correctly and it may result in unexpected results. <\/p>\n
Run the following command to install the mbstring extension for PHP 7.0 on Raspbian Stretch Lite:<\/p>\n
\r\nsudo apt-get install php7.0-mbstring \r\n<\/pre>\n
Creating a database user for administering your database via phpMyAdmin<\/h2>\n
The root user of MariaDB \/ MySQL could be using the Authentication Plugin<\/a> for authentication. <\/p>\n
The Authentication Plugin allows the user to use operating system credentials when connecting to MariaDB via Unix socket. This authentication mode cannot be used for logging into phpMyAdmin for administering your database.<\/p>\n
Hence, we need to create a database user for us to login through phpMyAdmin. To do so, we first get into MariaDB interactive shell with the following command:<\/p>\n
\r\nsudo mariadb\r\n<\/pre>\n
Or the MySQL interactive shell with the following command:<\/p>\n
\r\nsudo mysql\r\n<\/pre>\n
Once you are inside the interactive shell, run the following commands to create a database user that have the privileges to administer any database in your MariaDB \/ MySQL server:<\/p>\n
\r\nCREATE USER 'pmauser'@'localhost' IDENTIFIED BY 'password';\r\nGRANT ALL ON *.* TO 'pmauser'@'localhost';\r\n<\/pre>\n
Allocate a domain name for your phpMyAdmin site<\/h2>\n
The next step is to designate a domain name for accessing your phpMyAdmin site. If you already own a domain, you may want to create a subdomain out of your existing domain. For instance, I could use pma.techcoil.com<\/code> for my phpMyAdmin site residing on my Raspbian Stretch Lite.<\/p>\n
Getting a copy of phpMyAdmin<\/h2>\n
Once we had decided the domain for accessing our phpMyAdmin site, we can proceed to download a copy of phpMyAdmin. You can see the list of phpMyAdmin versions that are available for download via their download page<\/a>.<\/p>\n
As of this writing, the latest stable version is version 4.7.8<\/a>. Proceed to download the english version by running the following commands:<\/p>\n
\r\ncd \/var\/www\r\nsudo wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.7.8\/phpMyAdmin-4.7.8-english.tar.gz\r\nsudo tar -xvf phpMyAdmin-4.7.8-english.tar.gz\r\nsudo mv phpMyAdmin-4.7.8-english pma.techcoil.com\r\nsudo rm phpMyAdmin-4.7.8-english.tar.gz\r\n<\/pre>\n
Once the command completes, you should have the source codes for phpMyAdmin 4.7.8 available at the \/var\/www\/pma.techcoil.com<\/code> directory.<\/p>\n
Configuring blowfish secret for your phpMyAdmin site<\/h2>\n
The phpMyAdmin installation directory contains a sample configuration file which we can reference for configuring our phpMyAdmin site. <\/p>\n
To configure our phpMyAdmin site, we first make a copy of that configuration file:<\/p>\n
\r\nsudo cp \/var\/www\/pma.techcoil.com\/config.sample.inc.php \/var\/www\/pma.techcoil.com\/config.inc.php\r\n<\/pre>\n
Once we had done so, use nano<\/code> to open up the configuration file for editing:<\/p>\n
\r\nsudo nano \/var\/www\/pma.techcoil.com\/config.inc.php \r\n<\/pre>\n
Inside the editor, look for $cfg['blowfish_secret']<\/code> and provide a 32 character long blowfish secret:<\/p>\n
\r\n$cfg['blowfish_secret'] = '123456789012345678901234567890AB';\r\n<\/pre>\n
Once you had done so, save the file.<\/p>\n
Configuring Nginx to proxy HTTP traffic to your phpMyAdmin site<\/h2>\n
Once we had configured the blowfish secret for phpMyAdmin, the next step is to configure Nginx to proxy HTTP traffic to our PHP web application<\/a>.<\/p>\n
To do so, create a configuration file at \/etc\/nginx\/sites-enabled\/pma.techcoil.com.conf<\/code> with nano<\/code>:<\/p>\n
\r\nsudo nano \/etc\/nginx\/sites-enabled\/pma.techcoil.com.conf\r\n<\/pre>\n
And paste in the following contents:<\/p>\n
\r\nserver {\r\n\r\n        listen 80;\r\n        server_name pma.techcoil.com;\r\n        root \/var\/www\/pma.techcoil.com;\r\n        index index.php;\r\n\r\n        location \/ {\r\n                try_files $uri $uri\/ \/index.php?$args;\r\n        }\r\n\r\n        location ~ \\.php$ {\r\n                include fastcgi.conf;\r\n                fastcgi_pass unix:\/run\/php\/php7.0-fpm.sock;\r\n        }\r\n\r\n}\r\n<\/pre>\n
Once you had created the configuration file, restart Nginx with the following command:<\/p>\n
\r\nsudo systemctl restart nginx.service\r\n<\/pre>\n
Editing the hosts file to access your phpMyAdmin site from your work computer<\/h2>\n
Once you had restarted Nginx on your Raspbian Stretch Lite, go to your computer and add in the following contents to your hosts file:<\/p>\n
\r\n192.168.1.109 pma.techcoil.com\r\n<\/pre>\n
Accessing your phpMyAdmin site from your work computer<\/h2>\n
With the entry in your hosts file, you can access your phpMyAdmin site via the domain name that you had provided (for eg. http:\/\/pma.techcoil.com\/) with your browser. You should be able to see the login screen:<\/p>\n
\"phpMyAdmin<\/p>\n
Key in the details of the database user that you had created earlier to login to the dashboard. Once you had logged in successfully, you should be able to see the following screen:<\/p>\n
\"phpMyAdmin<\/p>\n
Setting up phpMyAdmin configuration storage<\/h2>\n
A warning message will be displayed at the bottom of the dashboard:<\/p>\n
\nThe phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
\nOr alternately go to 'Operations' tab of any database to set it up there.\n<\/p><\/blockquote>\n
Click on the \"Find out why\" link and then click on the \"Create\" link on the next page that follows. After you had clicked on the \"Create\" link, phpMyAdmin will create a database instance phpmyadmin<\/strong><\/code> for it to store configuration information such as navigation histories, bookmarks and etc.<\/p>\n
At this point in time, you have a setup that is sufficient for your to administer your MariaDB database on your Raspbian Stretch Lite. <\/p>\n
However, if you wish to access your phpMyAdmin site from outside your home network, read on to implement further configurations for your site.<\/p>\n
Let's Encrypt your phpMyAdmin site with a browser-trusted SSL\/TLS certificates <\/h2>\n
When you make your phpMyAdmin site communicate in HTTPS, you can be sure that the communication channel between your browser and your phpMyAdmin site is secure. <\/p>\n
Fortunately, Let's Encrypt<\/a> makes it easy for web masters to deploy secure web applications that serve HTTPS.  <\/p>\n
This section shows how you can secure your phpMyAdmin site with Let's Encrypt.<\/p>\n
Prequisites to serving your phpMyAdmin site via HTTPS<\/h3>\n
In a separate post, I had discussed the topic on how to host multiple websites from home<\/a>. Following those pointers, you will need the following pieces for your phpMyAdmin site to be accessed from outside your home network with Let's Encrypt browser-trusted certificate:<\/p>\n