In this tutorial, you will learn how to install and configure phpmyadmin Apache 2 and MySQL on Ubuntu 22.04 server.
This tutorial will show you steps by step guide on how to install phpMyAdmin, Apache2, and MySQL on your Ubuntu 22.04 server to manage your MySQL databases using the user-friendly web interface provided by phpMyAdmin.
How to Install phpMyAdmin, Apache 2, and MySQL on Ubuntu 22.04
Steps to install and configure phpmyadmin apache 2 and MySQL on Ubuntu 22.04 server.
- Step 1 – Update System Dependencies
- Step 2 – Install and Configure Apache 2
- Step 3 – Install and Configure MySQL
- Step 4 – Install and Configure PhpMyAdmin
Step 1 – Update System Dependencies
First of all, open your terminal or command line and execute the following commands into it to update the packages to the latest version available:
sudo apt update sudo apt upgrade
Step 2 – Install and Configure Apache 2
Next, execute the following command on command line or terminal to install apache 2 on ubuntu 22.04 system:
sudo apt install apache2
Once the Apache 2 installation has been finished. Now, you need to set up Uncomplicated Firewall (UFW) with Apache 2 to allow public access on default web ports for
sudo ufw app list
Then you will see all the listed applications.
- Apache: This profile opens port
80(normal, unencrypted web traffic)
- Apache Full: This profile opens both port
80(normal, unencrypted web traffic) and port
443(TLS/SSL encrypted traffic)
- Apache Secure: This profile opens only port
443(TLS/SSL encrypted traffic)
- OpenSSH: This profile opens port
22for SSH access.
If you are not going to use SSL, so you need to enable only the Apache profile. By using the following command, you can enable apache full on ubuntu server:
sudo ufw allow 'Apache Full'
Every process in Apache is managed with the
systemctl command. Check the status of Apache 2 with the following command.
sudo systemctl status apache2
Output ● apache2.service - The Apache HTTP Server Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled) Active: active (running) since Fri 2023-04-29 00:34:49 UTC; 2min 52s ago Docs: https://httpd.apache.org/docs/2.4/ Main PID: 12782 (apache2) Tasks: 55 (limit: 1151) Memory: 5.1M CPU: 52ms CGroup: /system.slice/apache2.service ├─12782 /usr/sbin/apache2 -k start ├─12784 /usr/sbin/apache2 -k start └─12785 /usr/sbin/apache2 -k start
Step 3 – Install and Configure MySQL
Once you have installed Apache 2 on Ubuntu server. Next, you need to install and configure mysql on ubuntu 22.04.
So, execute the following command on the terminal or command line to install MySQL server on ubuntu server with Apache 2:
sudo apt install mysql-server
During the installation process, you’ll be prompted to set a password for the MySQL root user. Make sure to choose a strong password and remember it.
To secure your MySQL installation, execute the following command and follow the prompts:
Once you have executed this command. Then the questions given below in the prompt will appear:
- You will be presented with a screen where MySQL asks whether you would like to activate the VALIDATE PASSWORD PLUGIN. For now, keeping things simple, type no.
- In the next type the root password of your choice. Confirm it again.
- In the next screen MySql will ask whether to remove anonymous users. Type yes
- Disallow root login remotely? Type No
- Remove test database and access to it? Type Yes
- Reload privilege tables now? Type Yes
If you want to check whether MySQL is working correctly by logging into the database, so you can execute the following command on terminal:
sudo mysql -u root -p
This command will ask for the password. Please Enter the password that you enter while securing the MySQL and hit enter will log in into MySQL:
Now, Type exit on ssh terminal to get out of MySql:
Step 4 – Install and Configure PhpMyAdmin
Execute the following command on the terminal or command line to install PHPmyadmin on the ubuntu apache 2 server:
sudo apt install phpmyadmin
During the installation process, you’ll be prompted to choose a web server. Select
apache2 and press
You’ll also be asked if you want to configure the database for phpmyadmin with dbconfig-common. Choose
Next, you’ll be prompted to set a password for the phpMyAdmin database user. This should be a separate password from the MySQL root password. Choose a strong password and remember it.
By default, phpMyAdmin is not accessible from the web. We’ll create a symbolic link for phpMyAdmin in the Apache web directory to make it accessible.
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin sudo systemctl reload apache2
Next, execute the following command on the terminal to login into your MySQL server:
sudo mysql -u root -p
Next, execute the following query on the terminal to allow root access login into your MySQL using PHPMyAdmin:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Note that, Replace the password with the root password you entered while installing MySql.
Next, execute the following query to flush privileges for your root user:
Finally, Execute the following command on the terminal to restart Apache 2 server:
sudo service apache2 restart
Congratulations! You have successfully installed phpMyAdmin, Apache2, and MySQL on your Ubuntu 22.04 server. You can now efficiently manage your MySQL databases using the user-friendly web interface provided by phpMyAdmin.