INSTALL PHYMYADMIN - Revision history

Bacchas: /* Installing phpMyAdmin on Ubuntu Server */

2026-11-10T17:03:14Z

Installing phpMyAdmin on Ubuntu Server

← Older revision		Revision as of 17:03, 10 November 2026
Line 31:		Line 31:
	On Ubuntu, MySQL's root account uses socket authentication, so logging in as root with a password through phpMyAdmin will fail. Create a dedicated admin user instead:		On Ubuntu, MySQL's root account uses socket authentication, so logging in as root with a password through phpMyAdmin will fail. Create a dedicated admin user instead:

	~~<syntaxhighlight lang="bash">~~		sudo mysql
	sudo mysql
	~~</syntaxhighlight>~~		CREATE USER 'pmaadmin'@'localhost' IDENTIFIED BY 'a-strong-password';
			GRANT ALL PRIVILEGES ON . TO 'pmaadmin'@'localhost' WITH GRANT OPTION;
			FLUSH PRIVILEGES;
			EXIT;

	~~<syntaxhighlight lang="sql">~~
	~~CREATE USER 'pmaadmin'@'localhost' IDENTIFIED BY 'a-strong-password';~~
	~~GRANT ALL PRIVILEGES ON . TO 'pmaadmin'@'localhost' WITH GRANT OPTION;~~
	~~FLUSH PRIVILEGES;~~
	~~EXIT;~~
	~~</syntaxhighlight>~~

	Log in to phpMyAdmin as <code>pmaadmin</code>.		Log in to phpMyAdmin as <code>pmaadmin</code>.
Line 49:		Line 46:
	==== Restrict access by IP ====		==== Restrict access by IP ====
	Edit <code>/etc/apache2/conf-available/phpmyadmin.conf</code> and add this inside the <code><Directory /usr/share/phpmyadmin></code> block:		Edit <code>/etc/apache2/conf-available/phpmyadmin.conf</code> and add this inside the <code><Directory /usr/share/phpmyadmin></code> block:

	~~<syntaxhighlight~~

Bacchas: /* Installing phpMyAdmin on Ubuntu Server */

2026-11-10T17:02:01Z

Installing phpMyAdmin on Ubuntu Server

← Older revision		Revision as of 17:02, 10 November 2026
Line 1:		Line 1:
	== Installing phpMyAdmin on Ubuntu Server ==		== Installing phpMyAdmin on Ubuntu Server ==

	~~This guide assumes a working LAMP stack (Apache, MySQL, PHP) is already installed~~.		==== 1. Install the packages ====

	~~=== Prerequisites ===~~		sudo apt update
	* Ubuntu Server with Apache2, MySQL, and PHP installed		sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl
	* A user with <code>sudo~~</code> privileges~~

	~~=== Installation ===~~

	~~==== 1. Install the packages ====~~
	~~<syntaxhighlight lang="bash">~~
	~~sudo apt update~~
	~~sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl~~
	~~</syntaxhighlight>~~

	==== 2. Answer the installer prompts ====		==== 2. Answer the installer prompts ====
Line 29:		Line 21:

	==== 3. Enable mbstring and restart Apache ====		==== 3. Enable mbstring and restart Apache ====
	~~<syntaxhighlight lang="bash">~~
	sudo phpenmod mbstring		sudo phpenmod mbstring
	sudo systemctl restart apache2		sudo systemctl restart apache2
	~~</syntaxhighlight>~~

	phpMyAdmin is now available at <code>http://your-server-ip/phpmyadmin</code>.		phpMyAdmin is now available at <code>http://your-server-ip/phpmyadmin</code>.

Bacchas at 17:00, 10 November 2026

2026-11-10T17:00:20Z

← Older revision		Revision as of 17:00, 10 November 2026
Line 1:		Line 1:
	sudo apt update		== Installing phpMyAdmin on Ubuntu Server ==
	sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl
			This guide assumes a working LAMP stack (Apache, MySQL, PHP) is already installed.

			=== Prerequisites ===
			* Ubuntu Server with Apache2, MySQL, and PHP installed
			* A user with <code>sudo</code> privileges

			=== Installation ===

			==== 1. Install the packages ====
			<syntaxhighlight lang="bash">
			sudo apt update
			sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl
			</syntaxhighlight>

			==== 2. Answer the installer prompts ====
			{\| class="wikitable"
			! Prompt !! Action
			\|-
			\| Web server to configure \|\| Press '''Space''' to select '''apache2''', then Tab and Enter
			\|-
			\| Configure database with dbconfig-common \|\| Choose '''Yes'''
			\|-
			\| Password for the phpmyadmin user \|\| Set a password, or leave blank for a random one
			\|}

			{{Note\|If you skip selecting apache2, phpMyAdmin will not be wired into Apache.}}

			==== 3. Enable mbstring and restart Apache ====
			<syntaxhighlight lang="bash">
			sudo phpenmod mbstring
			sudo systemctl restart apache2
			</syntaxhighlight>

			phpMyAdmin is now available at <code>http://your-server-ip/phpmyadmin</code>.

			=== Creating an admin user ===
			On Ubuntu, MySQL's root account uses socket authentication, so logging in as root with a password through phpMyAdmin will fail. Create a dedicated admin user instead:

			<syntaxhighlight lang="bash">
			sudo mysql
			</syntaxhighlight>

			<syntaxhighlight lang="sql">
			CREATE USER 'pmaadmin'@'localhost' IDENTIFIED BY 'a-strong-password';
			GRANT ALL PRIVILEGES ON . TO 'pmaadmin'@'localhost' WITH GRANT OPTION;
			FLUSH PRIVILEGES;
			EXIT;
			</syntaxhighlight>

			Log in to phpMyAdmin as <code>pmaadmin</code>.

			=== Security hardening ===
			phpMyAdmin is a frequent target for bots. If the server is reachable from the internet, apply the following.

			==== Restrict access by IP ====
			Edit <code>/etc/apache2/conf-available/phpmyadmin.conf</code> and add this inside the <code><Directory /usr/share/phpmyadmin></code> block:

			<syntaxhighlight

Bacchas: Created page with " sudo apt update sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl"

2026-11-10T16:39:57Z

Created page with " sudo apt update sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl"

New page

sudo apt update
sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl