PhpMyAdmin

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Basic Installation

For installing the additional packages first activate community packages and update the package index

Install the required packages:

# apk add lighttpd php fcgi php-cgi

Configure Lighttpd

Edit lighttpd.conf (/etc/lighttpd/lighttpd.conf) and uncomment the line:

Contents of /etc/lighttpd/lighttpd.conf

... include "mod_fastcgi.conf" ...

Start lighttpd service and add it to default runlevel

# rc-service lighttpd start # rc-update add lighttpd default

Install extra packages:

apk add mariadb mariadb-client phpmyadmin

Configuring MySql

mariadb-install-db --user=mysql --datadir=/var/lib/mysql rc-service mariadb start && rc-update add mariadb default mariadb-secure-installation

Configuring phpMyAdmin

Change the folder permissions

chmod -R 755 /usr/share/webapps/ chown -R lighttpd:lighttpd /usr/share/webapps/phpmyadmin chown -R lighttpd:lighttpd /etc/phpmyadmin

Create a symlink to the phpmyadmin folder

ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin

Generate a Cookie encryption key

php -r 'echo bin2hex(random_bytes(16)) . PHP_EOL;'

Put the key in the phpmyadmin configuration file /etc/phpmyadmin/config.inc.php

Contents of /etc/phpmyadmin/config.inc.php

... $cfg['blowfish_secret'] = sodium_hex2bin('cookie_encryption_key_here'); ...

Log on your phpMyAdmin

Browse to: https://WEBSERVER_IP_ADDRESS/phpmyadmin and logon to phpMyAdmin using your MySQL user and password.