How to Install phpMyAdmin on Ubuntu 18.04

Posted on by Alex Gorzen | Updated:
Reading Time: 2 minutes

Working with a database can sometimes be intimidating, but PhpMyAdmin can simplify tasks by providing a control panel to view or edit your MySQL or MariaDB database.  In this quick tutorial, we’ll show you how to install PhpMyAdmin on an Ubuntu VPS server.

How to Install phpMyAdmin on Ubuntu 18.04

Preflight

Step 1: Update the apt package tool to ensure we are working with the latest and greatest.

apt update && upgrade

Step 2: Install PhpMyAdmin and PHP extensions for managing non-ASCII string and necessary tools.

apt install phpmyadmin php-mbstring php-gettext

During this installation you’ll be asked for the web server selection, we will select Apache2 and select ENTER.

apt_install1

In this step, you have the option for automatic setup or to create the database manually. For us, we will do the automatic installation by pressing ENTER for yes.

apt_install2

At this setup, you’ll be asked to set the PhpMyAdmin password. Specifically for the PhpMyAdmin user, phpmyadmin,  you’ll want to save this in a secure spot for later retrieval.

apt_install3

Step 3:  Enable PHP extension.

phpenmod mbstring

Note
If you’re running multiple domains on one server then you’ll want to configure your /etc/apache2/apache2.conf to enable PhpMyAdmin to work. vim /etc/apache2/apache2.confAdd:Include /etc/phpmyadmin/apache.conf

Step 4:  Restart the Apache service to recognize the changes made to the system.

systemctl restart apache2

Step 5: Verify PhpMyAdmin installation by going to http://ip/phpmyadmin (username phpmyadmin).

phpmyadmin1

Still having issues installing?  Our Liquid Web servers come with 24/7 technical support. You can open a ticket with us right away at support@liquidweb.com, give us a call at 800-580-4985 or, open a chat with us to speak to one of our Level 3 Support Admins or a Solutions Advisor today!

About the Author: Alex Gorzen

Alex Gorzen has been helping others with technology his whole life. He played with computers even before he could read and wants to make sure his children share that same love as they grow up. In his free time, he enjoys gardening, building things, and learning new skills.

Have Some Questions?

Our Sales and Support teams are available 24 hours by phone or e-mail to assist.

1.800.580.4985
1.517.322.0434

Latest Articles

Cloning an Existing Virtual Machine with VMware

Read Article

Podman vs Docker: A Comparison

Read Article

Five Steps to Create a Robots.txt File for Your Website

Read Article

Premium Business Email Pricing FAQ

Read Article

Microsoft Exchange Server Security Update

Read Article