phpMyAdmin

Requirements

Sudo
PHP
PHP-FPM

Installation

sudo pkg install phpMyAdmin-php71

Configuration

In the server section of Nginx, make the following changes (make sure to put this before your own www directory):

    server {
        ...
 
        location /phpmyadmin/ {
            alias  /usr/local/www/phpMyAdmin/;
            index  index.php index.html;
        }
 
        location ~ ^/phpmyadmin/(.*\.php)$ {
            root           /usr/local/www/phpMyAdmin/;
            fastcgi_pass   unix:/var/run/php-fpm.sock;
            include        fastcgi_params;
            fastcgi_param  SCRIPT_FILENAME /usr/local/www/phpMyAdmin/$1;
            fastcgi_param  DOCUMENT_ROOT /usr/local/www/phpMyAdmin;
        }
    }

After making the changes, restart Nginx:

sudo service nginx restart

You are also required to set blowfish_secret in the configuration file otherwise phpMyAdmin will complain. First, open the file:

sudo ee /usr/local/www/phpMyAdmin/config.inc.php

and add a new entry:

$cfg['blowfish_secret'] = 'some_value';

You should replace some_value with a code you can generate here: Blowfish Secret Generator.

Usage

Then point your browser to username.it.pointpark.edu/phpmyadmin/ and you should be presented with the phpMyAdmin login page. Use the account information from when you installed MySQL to get access.

Leave A Reply

Your email address will not be published.