Installing phpMyAdmin

Use apt to install phpMyAdmin and supportive packages:

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 SPACETAB, and then ENTER to select Apache.

  • 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, and restart Apache service:

sudo phpenmod mbstring
sudo systemctl restart apache2

Create dedicated user for phpMyAdmin:

mysql -u root -p

mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'sammy'@'localhost' WITH GRANT OPTION;
mysql> exit

You can now access the web interface by visiting your server’s domain name or public IP address followed by /phpmyadmin:

http://your_domain_or_IP/phpmyadmin