How To Install and Secure phpMyAdmin on Ubuntu 18.04?
To get started, we will install phpMyAdmin from the default Ubuntu repositories.
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.
Warning: When the prompt appears, “apache2” is highlighted, but not selected. If you do not hit
SPACE to select Apache, the installer will not move the necessary files during installation. Hit
TAB, and then
ENTER to select Apache.
- For the server selection, choose
Yeswhen asked whether to use
dbconfig-commonto 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
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.