phpMyAdmin

​phpMyAdmin on Crin1 at ​https://phpmyadmin.crin.org/ was installed on ticket:8.

The site is password protected using HTTP Digest Authentication so you need to get a username and password to access it (ask chris@…), this is to prevent brute force attacks on the MySQL accounts.

The site uses a ​CACert SSL/TLS certificate and to avoid HTTPS warnings in your browser you need to install ​the root certificates for Firefox simply follow these links: ​Class 1 CACert Root, ​Class 3 CACert Root.

To add additional username / passwords on Crin1

sudo -i
cd /etc/phpmyadmin
export NEWUSER="username"
htdigest .htpasswd phpmyadmin $NEWUSER