PhpMyAdmin

Updated 21 March 2019

We suggest installing PhpMyAdmin from the source.

Creating the paths

Create the necessary directories:

Downloading the source code

Then go to the archive location on the developer's site and get it:

You may need to install Unzip to extract the archive:

Now extract the files:

Rename the phpMyAdmin-4.7.5-all-languages directory to htdocs:

Define the necessary permissions for the pma directory and all nested files and directories:

PhpMyAdmin configuration file, handled by Nginx:

PhpMyAdmin uses http and its domain name is pmalempcss.calculate.loc. Create the configuration file /etc/nginx/conf.d/pma.conf and edit it as shown below:

nginx
# pmalempcss.calculate.loc
server {
    listen 80;
    server_name pmalempcss.calculate.local;
    access_log /var/www/pma/logs/pma.access_log main;
    error_log /var/www/pma/logs/pma.error_log info;
    root /var/www/pma/htdocs/;
    index index.php index.html index.htm;
    location ~ \.php$ {
           try_files $uri =404;
           include /etc/nginx/fastcgi.conf;
           fastcgi_pass unix:/run/php-fpm.socket;
       }
}

After the Nginx configuration file has been created, check it and restart the service:

Add the necessary data to the DNS server of the local network or edit /etc/hosts on the local computer that will be used for the connection:

192.168.0.10 pmalempcss.calculate.local

Creating a phpMyAdmin configuration file

If you type http://pmalempcss.calculate.loc/setup, a page with options will open and the PhpMyAdmin configuration file will be saved.

Here is a sample configuration file.

<?php
/*
 * Generated configuration file
 * Generated by: phpMyAdmin 4.7.5 setup script
 * Date: Sat, 18 Nov 2017 15:51:14 +0000
 */
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* End of servers configuration */
$cfg['DefaultLang'] = 'ru';
$cfg['blowfish_secret'] = '5"+y&lt;2TqP+qrobW`%c!!9"BRYdIVZGIL';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '/var/www/pma/upload';
$cfg['SaveDir'] = '/var/www/pma/save';
?&gt;

Configure the access rights for the configuration file:

To work with databases, go to ~http://pmalempcss.calculate.loc~~ in your web browser.
Once the root login and password specified during the initial configuration of MariaDB, you will be directed to the main PhpMyAdmin page, where you will be able to freely manage your databases.