Requirements
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.