Difference between revisions of "INSTALL PHYMYADMIN"
Jump to navigation
Jump to search
(Created page with " sudo apt update sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Installing phpMyAdmin on Ubuntu Server == | |||
==== 1. Install the packages ==== | |||
sudo apt update | sudo apt update | ||
sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl | sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl | ||
==== 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 ==== | |||
sudo phpenmod mbstring | |||
sudo systemctl restart apache2 | |||
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: | |||
sudo mysql | |||
CREATE USER 'pmaadmin'@'localhost' IDENTIFIED BY 'a-strong-password'; | |||
GRANT ALL PRIVILEGES ON *.* TO 'pmaadmin'@'localhost' WITH GRANT OPTION; | |||
FLUSH PRIVILEGES; | |||
EXIT; | |||
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: | |||
Latest revision as of 17:03, 10 November 2026
Installing phpMyAdmin on Ubuntu Server
1. Install the packages
sudo apt update sudo apt install -y phpmyadmin php-mbstring php-zip php-gd php-json php-curl
2. Answer the installer prompts
| 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 |
3. Enable mbstring and restart Apache
sudo phpenmod mbstring sudo systemctl restart apache2
phpMyAdmin is now available at http://your-server-ip/phpmyadmin.
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:
sudo mysql
CREATE USER 'pmaadmin'@'localhost' IDENTIFIED BY 'a-strong-password'; GRANT ALL PRIVILEGES ON *.* TO 'pmaadmin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; EXIT;
Log in to phpMyAdmin as pmaadmin.
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 /etc/apache2/conf-available/phpmyadmin.conf and add this inside the <Directory /usr/share/phpmyadmin> block: