In this article, we will have explained the necessary steps to install and configure phpMyAdmin on Ubuntu 18.04 LTS. Before continuing with this tutorial, make sure you are logged in as a user with sudo privileges. All the commands in this tutorial should be run as a non-root user.
phpMyAdmin is an open-source, web-based administration tool for managing the MySQL and MariaDB database. It is written in PHP and is one of the most popular database administration tools used by web hosting companies to enable novice system administrators to carry out database activities.
Install phpMyAdmin on Ubuntu 18.04
Step 1. First, before you start installing any package on your Ubuntu server, we always recommend making sure that all system packages are updated.
Step 2. Install LAMP stack on Ubuntu.
It is assumed that you have already installed LAMP stack on Ubuntu 18.04. If not, please check out the following tutorial.
Step 3. Install phpMyAdmin.
Now to install phpMyAdmin and required extensions please use the following command:
First, you will need to select apache as web server. Select Apache and click OK.
Now enter the following command to enable php-mbstring extension:
Restart apache2 using following command:
Step 4. Configure phpMyAdmin.
Apache configuration file will be created at /etc/phpmyadmin/apache.conf. You can edit configuration file:
Then, restart Apache service:
Step 5. Create Database User.
First, open MySQL shell by typing following command:
Create a new user by typing following command:
Now you can login with created users credentials and access phpMyAdmin:
That’s all you need to do to install phpMyAdmin on Ubuntu 18.04 LTS. I hope you find this quick tip helpful. If you have questions or suggestions, feel free to leave a comment below.