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.