Difference between revisions of "INSTALL PHYMYADMIN"
Jump to navigation
Jump to search
| 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: | ||
sudo mysql | |||
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>. | 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: | ||
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: