How to Install phpMyAdmin on Ubuntu 24.04

Published on February 21, 2025•Updated on February 21, 2025

phpMyAdmin is an open-source web-based tool used to manage MySQL databases. It offers a user-friendly interface for creating, modifying, and deleting databases, tables, and fields. You can also use phpMyAdmin to manage users, import and export databases, and execute SQL statements. phpMyAdmin offers a beginner-friendly web interface that allows you to run SQL queries on a database server without using the command-line interface (CLI).

This article explains how to install phpMyAdmin on Ubuntu 24.04. You will create MySQL databases, and access the phpMyAdmin interface to manage users and databases.

Prerequisites

Before you begin, you need to:

Have access to an Ubuntu 24.04 instance as a non-root sudo user.

Set Up the MySQL Database Server

Follow the steps below to set up the MySQL database server and create a sample database to use with phpMyAdmin.

Update the APT package information index.
console
```
$ sudo apt update
```
Install MySQL server if it's not installed.
console
```
$ sudo apt install mysql-server -y
```
Log in to the MySQL database server.
console
```
$ sudo mysql
```
Create a sample my_company database.
sql
```
mysql> CREATE DATABASE my_company;
```
Create a new company_admin MySQL user with a strong password. Replace your_password with a strong password.
sql
```
mysql> CREATE USER 'company_admin'@'localhost' IDENTIFIED BY 'your_password';
```

Grant the company_admin user full privileges to the my_company database.

                            sql
                            
mysql> GRANT ALL PRIVILEGES ON my_company.* TO 'company_admin'@'localhost';

Flush the MySQL privileges table to apply the user changes.
sql
```
mysql> FLUSH PRIVILEGES;
```
Exit the MySQL console.
sql
```
mysql> EXIT;
```

Install phpMyAdmin

phpMyAdmin is available in the default package repositories on Ubuntu 24.04. Follow the steps below to install phpMyAdmin using the APT package manager.

Update the APT package information index.
console
```
$ sudo apt update
```

Install PHP and all required PHP extensions.

                            console
                            
$ sudo apt install php php-mysql php-mbstring php-json php-xml php-curl php-zip php-common -y

Install phpMyAdmin.
console
```
$ sudo apt install phpmyadmin -y
```
Select the following phpMyAdmin configuration options when prompted:
- Web server to reconfigure automatically: Press Space to select apache2 and press Enter to save your selection.
- Configure database for phpmyadmin with dbconfig-common? Keep Yes selected and press Enter to configure the MySQL database.
- MySQL application password for phpmyadmin: Enter a strong password for the phpMyAdmin database and press Enter to confirm it. Then, enter the password again and press Enter to apply the database changes.

Verify that the phpMyAdmin installation is successful.

                            console
                            
$ dpkg -l | awk '/phpmyadmin / {print}'

Output:

ii  phpmyadmin                           4:5.2.1+dfsg-3                          all          MySQL web administration tool

Configure phpMyAdmin

phpMyAdmin includes a default Apache virtual host configuration file used to serve the /phpmyadmin endpoint using your server's IP or domain. Follow the steps below to verify that the phpMyAdmin configuration is enabled and start the Apache web server.

Enable the phpMyAdmin virtual host configuration using the a2enconf command.
console
```
$ sudo a2enconf phpmyadmin.conf
```
Output:
```
Conf phpmyadmin already enabled
```
Restart Apache to apply the configuration changes.
console
```
$ sudo systemctl restart apache2
```

View the Apache web server status and verify that it's running.

                            console
                            
$ sudo systemctl status apache2

Output:

● apache2.service - The Apache HTTP Server
     Loaded: loaded (/usr/lib/systemd/system/apache2.service; enabled; preset: enabled)
     Active: active (running) since Wed 2025-02-19 14:03:08 UTC; 5min ago
       Docs: https://httpd.apache.org/docs/2.4/
    Process: 84623 ExecReload=/usr/sbin/apachectl graceful (code=exited, status=0/SUCCESS)
   Main PID: 74567 (apache2)
      Tasks: 6 (limit: 1061)

View the UFW status and verify that the firewall is active.
console
```
$ sudo ufw status
```
- Run the following command to install UFW and allow SSH connections if it's unavailable.
  console
  $ sudo apt install ufw -y && sudo ufw allow ssh
Allow the Apache Full profile through the firewall to enable HTTP and HTTPS connections on the server.
console
```
$ sudo ufw allow 'Apache Full'
```
Reload UFW to apply the firewall configuration changes.
console
```
$ sudo ufw reload
```

Access phpMyAdmin

Follow the steps below to access phpMyAdmin and manage the sample MySQL database you created earlier.

Access the /phpmyadmin endpoint using your server's IP address or domain name in a web browser such as Chrome.
```
http://your_server_ip/phpmyadmin
```
Log in to phpMyAdmin using the sample company_admin MySQL user account credentials you created earlier.
Verify that the phpMyAdmin interface loads correctly in your web browser.
Click the my_company database on the left navigation menu to manage it.

Warning
Avoid logging in to phpMyAdmin using the MySQL root user account as this poses significant risks, including accidental deletions, modifications, and security vulnerabilities. Instead, always create a dedicated user account with the necessary permissions for a specific database(s). This ensures a more secure and controlled environment, reducing the risk of unintentional actions that could compromise your data and server incase a malicious user gets access to your database account.

Secure phpMyAdmin Endpoint

Basic authentication prompts users for a password to access the phpMyAdmin interface. Follow the steps below to secure the phpMyAdmin endpoint with basic authentication to prompt users for a password to manage databases.

Create a new .htpasswd file with a new username and password. Replace your_username with your desired username such as smith and enter your desired password when prompted.
console
```
$ sudo htpasswd -c /etc/phpmyadmin/.htpasswd your_username
```
Open the Apache virtual host configuration for phpMyAdmin.
console
```
$ sudo nano /etc/apache2/conf-available/phpmyadmin.conf
```
Add the following AllowOverride All directive within the /usr/share/phpmyadmin directory block.
apacheconf
```
AllowOverride All
```
Your modified directory block should be similar to the one below.
apacheconf
```
<Directory /usr/share/phpmyadmin>
    AllowOverride All
    ...
</Directory>
```
Create a new .htaccess file in the /usr/share/phpmyadmin/ directory.
console
```
$ sudo nano /usr/share/phpmyadmin/.htaccess
```
Add the following configurations to the .htaccess file.
apacheconf
```
AuthType Basic
AuthName "Restricted Access to PhpMyAdmin"
AuthUserFile /etc/phpmyadmin/.htpasswd
Require valid-user
```
In the above .htaccess file:

The above .htaccess configuration enables basic authentication on the phpMyAdmin endpoint. Within the configuration:
- AuthType Basic: Specifies the authentication type as Basic.
- AuthName "Restricted Access to PhpMyAdmin": Sets a custom message to display in the sign-in prompt.
- AuthUserFile /etc/phpmyadmin/.htpasswd: Sets /etc/phpmyadmin/.htpasswd as the basic authentication file that includes the allowed users and encrypted passwords.
- Require valid-user: Requests a valid user to access the phpMyAdmin interface.
Restart Apache to apply the configuration changes.
console
```
$ sudo systemctl restart apache2
```
Access phpMyAdmin again and verify that you are prompted for a user password to log in.
```
http://your_server_ip/phpmyadmin
```
Log in to phpMyAdmin using your MySQL user credentials to manage databases on your server.

Troubleshoot phpMyAdmin

Follow the sections below to troubleshoot your phpMyAdmin installation in case of any common errors.

Verify that the MySQL database server is running.
console
```
$ sudo systemctl status mysql
```
Verify your MySQL username and password.
View the phpMyAdmin configuration file and find any possible errors.
console
```
$ sudo nano /etc/phpmyadmin/config.inc.php
```

Internal Server Error

View Apache error logs for detailed information.
console
```
$ sudo tail -f /var/log/apache2/error.log
```

Install all required PHP extensions.

                            console
                            
$ sudo apt install php-mysql php-mbstring php-json php-xml php-curl php-zip php-common -y

Access Denied

Create a new MySQL user.

                            sql
                            
mysql> CREATE USER 'your_username'@'localhost' IDENTIFIED BY 'your_password';

Grant the user full privileges to your target database.

                            sql
                            
mysql> GRANT ALL PRIVILEGES ON *.* TO 'your_username'@'localhost' WITH GRANT OPTION;

Flush the MySQL privileges table to apply changes.
sql
```
mysql> FLUSH PRIVILEGES;
```
Exit the MySQL database console and access phpMyAdmin again.
sql
```
mysql> EXIT;
```

Conclusion

You have installed phpMyAdmin on Ubuntu 24.04. phpMyAdmin provides a convenient web-based interface for managing your MySQL databases. You can now use phpMyAdmin to perform database administration tasks to manage databases, insert records, and query tables to generate reports. For more information and configuration options, visit the phpMyAdmin documentation.

How to Install phpMyAdmin on Ubuntu 24.04

Prerequisites

Set Up the MySQL Database Server

Install phpMyAdmin

Configure phpMyAdmin

Access phpMyAdmin

Secure phpMyAdmin Endpoint

Troubleshoot phpMyAdmin

Internal Server Error

Access Denied

Conclusion

Products

Features

Solutions

Marketplace

Resources

Company

Tech Talks

Vultr Blogs

How to Install phpMyAdmin on Ubuntu 24.04

Prerequisites

Set Up the MySQL Database Server

Install phpMyAdmin

Configure phpMyAdmin

Access phpMyAdmin

Secure phpMyAdmin Endpoint

Troubleshoot phpMyAdmin

phpMyAdmin Login Fails

Internal Server Error

Access Denied

Conclusion

Tech Talks

Vultr Blogs