PhpMyAdmin - Revision history

Viperfang at 10:50, 27 September 2025

2025-09-27T10:50:52Z

← Older revision		Revision as of 10:50, 27 September 2025
Line 18:		Line 18:

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

2025-09-27T10:48:37Z

add cookie encryption key

← Older revision		Revision as of 10:48, 27 September 2025
Line 23:		Line 23:

	{{Cmd\|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}		{{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 ==		== Log on your phpMyAdmin ==

2025-09-27T10:26:52Z

Use the package as it bring in dependencies

← Older revision		Revision as of 10:26, 27 September 2025
Line 5:		Line 5:

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

	== Configuring MySql ==		== Configuring MySql ==
Line 13:		Line 13:
	mariadb-secure-installation</nowiki>}}		mariadb-secure-installation</nowiki>}}

	== ~~Installing~~ phpMyAdmin ==		== Configuring 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		Change the folder permissions

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

	Create a symlink to the ''phpmyadmin'' folder		Create a symlink to the ''phpmyadmin'' folder

2025-09-27T09:59:29Z

change move so exact version isn't required

← Older revision		Revision as of 09:59, 27 September 2025
Line 30:		Line 30:
	Rename the folder		Rename the folder

	{{Cmd\|mv phpMyAdmin-~~5.2.1-all-languages~~ phpmyadmin}}		{{Cmd\|mv phpMyAdmin-* phpmyadmin}}

	Change the folder permissions		Change the folder permissions

2025-09-27T09:57:40Z

← Older revision		Revision as of 09:57, 27 September 2025
Line 21:		Line 21:

	{{Cmd\|cd /usr/share/webapps		{{Cmd\|cd /usr/share/webapps
	wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz}}		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		Unpack the archive and remove the archive

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

	Rename the folder		Rename the folder

2025-09-27T09:48:45Z

Updated packages and commands for mariadb

← Older revision		Revision as of 09:48, 27 September 2025
Line 5:		Line 5:

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

	== Configuring MySql ==		== Configuring MySql ==

	{{Cmd\|<nowiki>~~/usr/bin/mysql_install_db~~ --user=mysql		{{Cmd\|<nowiki>mariadb-install-db --user=mysql --datadir=/var/lib/mysql
	rc-service ~~mysql~~ start && rc-update add ~~mysql~~ default		rc-service mariadb start && rc-update add mariadb default
	~~/usr/bin/mysqladmin~~ -~~u root password 'password'~~</nowiki>}}		mariadb-secure-installation</nowiki>}}

	== Installing phpMyAdmin ==		== Installing phpMyAdmin ==

2023-11-17T09:53:29Z

replace /etc/init.d with rc-service

← Older revision		Revision as of 09:53, 17 November 2023
Line 10:		Line 10:

	{{Cmd\|<nowiki>/usr/bin/mysql_install_db --user=mysql		{{Cmd\|<nowiki>/usr/bin/mysql_install_db --user=mysql
	~~/etc/init.d/~~mysql start && rc-update add mysql default		rc-service mysql start && rc-update add mysql default
	/usr/bin/mysqladmin -u root password 'password'</nowiki>}}		/usr/bin/mysqladmin -u root password 'password'</nowiki>}}

2023-09-03T22:36:14Z

Installing phpMyAdmin: Update

← Older revision		Revision as of 22:36, 3 September 2023
Line 21:		Line 21:

	{{Cmd\|cd /usr/share/webapps		{{Cmd\|cd /usr/share/webapps
	wget https://files.~~directadmin~~.~~com~~/~~services~~/~~all/phpMyAdmin~~/phpMyAdmin-5.0.2-all-languages.tar.gz~~{{dead link}}~~}}		wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz}}

	Unpack the archive and remove the archive		Unpack the archive and remove the archive

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

	Rename the folder		Rename the folder

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

	Change the folder permissions		Change the folder permissions

2023-08-25T03:29:47Z

Marked a dead link.

← Older revision		Revision as of 03:29, 25 August 2023
Line 21:		Line 21:

	{{Cmd\|cd /usr/share/webapps		{{Cmd\|cd /usr/share/webapps
	wget https://files.directadmin.com/services/all/phpMyAdmin/phpMyAdmin-5.0.2-all-languages.tar.gz}}		wget https://files.directadmin.com/services/all/phpMyAdmin/phpMyAdmin-5.0.2-all-languages.tar.gz{{dead link}}}}

	Unpack the archive and remove the archive		Unpack the archive and remove the archive

2023-08-14T04:02:07Z

Installing phpMyAdmin: Someone more familiar needs to see if we can tighten the permissions even more.

← Older revision		Revision as of 04:02, 14 August 2023
Line 34:		Line 34:
	Change the folder permissions		Change the folder permissions

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

	Create a symlink to the ''phpmyadmin'' folder		Create a symlink to the ''phpmyadmin'' folder