Alpine Linux - User contributions [en]

PhpMyAdmin

2025-09-27T10:50:52Z

Viperfang:

[https://www.phpmyadmin.net 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.

== Install lighttpd, PHP and MySql ==
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add mariadb mariadb-client phpmyadmin}}

== Configuring MySql ==

{{Cmd|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start && rc-update add mariadb default
mariadb-secure-installation</nowiki>}}

== Configuring phpMyAdmin ==

Change the folder permissions

{{Cmd|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

{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}

Generate a Cookie encryption key
{{Cmd|php -r 'echo bin2hex(random_bytes(16)) . PHP_EOL;'}}

Put the key in the phpmyadmin configuration file {{Path|/etc/phpmyadmin/config.inc.php}}
{{cat|/etc/phpmyadmin/config.inc.php|<nowiki>...
$cfg['blowfish_secret'] = sodium_hex2bin('cookie_encryption_key_here');
...</nowiki>}}

== Log on your phpMyAdmin ==

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

[[Category:PHP]]
[[Category:SQL]]

PhpMyAdmin

2025-09-27T10:48:37Z

Viperfang: add cookie encryption key

[https://www.phpmyadmin.net 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.

== Install lighttpd, PHP and MySql ==
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add mariadb mariadb-client phpmyadmin}}

== Configuring MySql ==

{{Cmd|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start && rc-update add mariadb default
mariadb-secure-installation</nowiki>}}

== Configuring phpMyAdmin ==

Change the folder permissions

{{Cmd|chmod -R 755 /usr/share/webapps/
chown -R lighttpd:lighttpd /etc/phpmyadmin}}

Create a symlink to the ''phpmyadmin'' folder

{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}

Generate a Cookie encryption key
{{Cmd|php -r 'echo bin2hex(random_bytes(16)) . PHP_EOL;'}}

Put the key in the phpmyadmin configuration file {{Path|/etc/phpmyadmin/config.inc.php}}
{{cat|/etc/phpmyadmin/config.inc.php|<nowiki>...
$cfg['blowfish_secret'] = sodium_hex2bin('cookie_encryption_key_here');
...</nowiki>}}

== Log on your phpMyAdmin ==

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

[[Category:PHP]]
[[Category:SQL]]

PhpMyAdmin

2025-09-27T10:26:52Z

Viperfang: Use the package as it bring in dependencies

[https://www.phpmyadmin.net 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.

== Install lighttpd, PHP and MySql ==
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add mariadb mariadb-client phpmyadmin}}

== Configuring MySql ==

{{Cmd|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start && rc-update add mariadb default
mariadb-secure-installation</nowiki>}}

== Configuring phpMyAdmin ==

Change the folder permissions

{{Cmd|chmod -R 755 /usr/share/webapps/
chown -R lighttpd:lighttpd /etc/phpmyadmin}}

Create a symlink to the ''phpmyadmin'' folder

{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}

== Log on your phpMyAdmin ==

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

[[Category:PHP]]
[[Category:SQL]]

PhpMyAdmin

2025-09-27T09:59:29Z

Viperfang: change move so exact version isn't required

[https://www.phpmyadmin.net 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.

== Install lighttpd, PHP and MySql ==
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add mariadb mariadb-client php-mysqli}}

== Configuring MySql ==

{{Cmd|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start && rc-update add mariadb default
mariadb-secure-installation</nowiki>}}

== Installing phpMyAdmin ==

Create a directory named {{Path|webapps}}

{{Cmd|mkdir -p /usr/share/webapps/}}
Download the source code

{{Cmd|cd /usr/share/webapps
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.2/phpMyAdmin-5.2.2-all-languages.tar.gz -O phpMyAdmin.tar.gz}}

Unpack the archive and remove the archive

{{Cmd|tar zxvf phpMyAdmin.tar.gz
rm phpMyAdmin.tar.gz}}

Rename the folder

{{Cmd|mv phpMyAdmin-* phpmyadmin}}

Change the folder permissions

{{Cmd|chmod -R 755 /usr/share/webapps/}}

Create a symlink to the ''phpmyadmin'' folder

{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}

== Log on your phpMyAdmin ==

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

[[Category:PHP]]
[[Category:SQL]]

PhpMyAdmin

2025-09-27T09:57:40Z

Viperfang:

[https://www.phpmyadmin.net 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.

== Install lighttpd, PHP and MySql ==
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add mariadb mariadb-client php-mysqli}}

== Configuring MySql ==

{{Cmd|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start && rc-update add mariadb default
mariadb-secure-installation</nowiki>}}

== Installing phpMyAdmin ==

Create a directory named {{Path|webapps}}

{{Cmd|mkdir -p /usr/share/webapps/}}
Download the source code

{{Cmd|cd /usr/share/webapps
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.2/phpMyAdmin-5.2.2-all-languages.tar.gz -O phpMyAdmin.tar.gz}}

Unpack the archive and remove the archive

{{Cmd|tar zxvf phpMyAdmin.tar.gz
rm phpMyAdmin.tar.gz}}

Rename the folder

{{Cmd|mv phpMyAdmin-5.2.1-all-languages phpmyadmin}}

Change the folder permissions

{{Cmd|chmod -R 755 /usr/share/webapps/}}

Create a symlink to the ''phpmyadmin'' folder

{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}

== Log on your phpMyAdmin ==

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

[[Category:PHP]]
[[Category:SQL]]

PhpMyAdmin

2025-09-27T09:48:45Z

Viperfang: Updated packages and commands for mariadb

[https://www.phpmyadmin.net 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.

== Install lighttpd, PHP and MySql ==
{{:Setting Up Lighttpd With FastCGI}}

Install extra packages:
{{Cmd|apk add mariadb mariadb-client php-mysqli}}

== Configuring MySql ==

{{Cmd|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
rc-service mariadb start && rc-update add mariadb default
mariadb-secure-installation</nowiki>}}

== Installing phpMyAdmin ==

Create a directory named {{Path|webapps}}

{{Cmd|mkdir -p /usr/share/webapps/}}
Download the source code

{{Cmd|cd /usr/share/webapps
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz}}

Unpack the archive and remove the archive

{{Cmd|tar zxvf phpMyAdmin-5.2.1-all-languages.tar.gz
rm phpMyAdmin-5.2.1-all-languages.tar.gz}}

Rename the folder

{{Cmd|mv phpMyAdmin-5.2.1-all-languages phpmyadmin}}

Change the folder permissions

{{Cmd|chmod -R 755 /usr/share/webapps/}}

Create a symlink to the ''phpmyadmin'' folder

{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}

== Log on your phpMyAdmin ==

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

[[Category:PHP]]
[[Category:SQL]]

Setting Up Lighttpd With FastCGI

2025-09-27T09:21:31Z

Viperfang: Use default version of php, as the binary is sym linked anyway. 82 was already out of date.

== Basic Installation ==

For installing the additional packages first '''[[Repositories#Managing_repositories|activate community packages]]''' and update the package index

Install the required packages:

{{Cmd|# apk add {{pkg|lighttpd}} {{pkg|php}} {{pkg|fcgi}} {{pkg|php-cgi}}}}

== Configure Lighttpd ==

Edit lighttpd.conf ({{Path|/etc/lighttpd/lighttpd.conf}}) and uncomment the line:

{{cat|/etc/lighttpd/lighttpd.conf|...
include "mod_fastcgi.conf"
...}}

== Start <code>lighttpd</code> service and add it to default runlevel ==

{{Cmd|<nowiki># rc-service lighttpd start
# rc-update add lighttpd default
</nowiki>}}

[[Category:Server]]
[[Category:PHP]]