| 1 | [[PageOutline(2-5, Table of Contents, floated)]] |
| 2 | = phpMyAdmin = |
| 3 | |
| 4 | [http://www.phpmyadmin.net/ phpMyAdmin] on [[Crin1]] at https://phpmyadmin.crin.org/ was installed on ticket:8. |
| 5 | |
| 6 | The site is password protected using HTTP Digest Authentication so you need to get a username and password to access it (ask [mailto:chris@webarchitects.co.uk chris@webarchitects.co.uk]), this is to prevent brute force attacks on the MySQL accounts. |
| 7 | |
| 8 | The site uses a [http://www.cacert.org/ CACert] SSL/TLS certificate and to avoid HTTPS warnings in your browser you need to install [http://www.cacert.org/index.php?id=3 the root certificates] for Firefox simply follow these links: [http://www.cacert.org/certs/root.crt Class 1 CACert Root], [http://www.cacert.org/certs/class3.crt Class 3 CACert Root]. |
| 9 | |
| 10 | To add additional username / passwords on [[Crin1]] |
| 11 | |
| 12 | {{{ |
| 13 | sudo -i |
| 14 | cd /etc/phpmyadmin |
| 15 | export NEWUSER="username" |
| 16 | htdigest .htpasswd phpmyadmin $NEWUSER |
| 17 | }}} |