While many users require the functionality of a database management system such as MySQL, they may not feel happy interacting with the system individually from the MySQL prompt.
phpMyAdmin was created so that users can interact with MySQL through a web interface. In this guide, we will discuss how to install and protect phpMyAdmin so that you can securely use it to control your databases on an Ubuntu 18.04 system.
you’ve completed a LAMP (Linux, Apache, MySQL, and PHP) installation on your Ubuntu 18.04 server. First, we’ll assume that your server has a non-root user with sudo privileges, as well as a firewall configured with ufw.
Step 1 — Installing phpMyAdmin
This is done by updating your server’s package index and then using the apt packaging system to pull down the files and install them on your system:
sudo apt update sudo apt install phpmyadmin php-mbstring php-gettext
This will ask you a few questions in order to configure your installation correctly.
- For the server selection, choose apache2
- Select Yes when asked whether to use dbconfig-common to set up the database
- You will then be asked to choose and confirm a MySQL application password for phpMyAdmin
The installation process adds the phpMyAdmin Apache configuration file into the /etc/apache2/conf-enabled/ directory, where it is read automatically. The only thing you need to do is explicitly enable the mbstring PHP extension, which you can do by typing:
sudo phpenmod mbstring
Afterwards, restart Apache for your changes to be recognized:
sudo systemctl restart apache2
Create symbolic link
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin.conf sudo service apache2 reload
phpMyAdmin is now installed and configured. However, before you can log in and begin interacting with your MySQL databases, you will need to ensure that your MySQL users have the privileges required for interacting with the program.