×

This article covers how to install phpMyAdmin with Apache on Ubuntu 18.04 system. While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. phpMyAdmin was created so that users can interact with MySQL through a web interface. 


Important php packages includes:

  • php-mbstring: A module for managing non-ASCII strings and convert strings to different encodings.
  • php-zip: This extension supports uploading .zip files to phpMyAdmin.
  • php-gd: Enables support for the GD Graphics Library.
  • php-json: Provides PHP with support for JSON serialization.
  • php-curl: Allows PHP to interact with different kinds of servers using different protocols.



This article covers step by step process to install a LAMP stack on an Ubuntu 18.04 server. LAMP stack is a group of open-source software that is typically installed together to host dynamic websites. LAMP stands for Linux OS, with Apache web server, Data store in a MySQL database, and dynamic content is processed by PHP.


To Install Apache and Update the Firewall.

1. Install Apache using Ubuntu’s package manager, apt:

$ sudo apt update
$ sudo apt install apache2

2. Allow incoming HTTP and HTTPS traffic for this profile:

$ sudo ufw allow in "Apache Full"



This article covers how you can  seamlessly install phpMyAdmin on your Ubuntu Linux system.

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.

To Install phpMyAdmin on Ubuntu:
1. Update the apt package tool to ensure we are working with the latest and greatest.

$ apt update && upgrade

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.
Here, 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.
3. 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.
4. Enable PHP extension.

phpenmod mbstring

5. Restart the Apache service to recognize the changes made to the system.

# systemctl restart apache2




More Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on IbmiMedia.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com