How to Install PhpMyAdmin in Ubuntu 23.04

In this guide, we will demonstrate how PhpMyAdmin is installed on a Ubuntu 23.04 system. PhpMyAdmin requires a standalone Database or as part of the LEMP stack, installed and running on the system beforehand.

Prerequisites:

Server with Nginx, PHP, and MariaDB. You can find our LEMP Installation guide here.

Installing PhpMyAdmin

apt install phpmyadmin

Output:

root@ubuntu:~# apt install phpmyadmin
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
dbconfig-common dbconfig-mysql icc-profiles-free javascript-common
libjs-codemirror libjs-jquery libjs-jquery-metadata libjs-jquery-mousewheel
libjs-jquery-tablesorter libjs-jquery-timepicker libjs-jquery-ui
libjs-sphinxdoc libjs-underscore libmcrypt4 libzip4 php-bz2
php-composer-ca-bundle php-fig-http-message-util php-getallheaders
php-google-recaptcha php-mariadb-mysql-kbs php-mcrypt php-nikic-fast-route
php-phpmyadmin-motranslator php-phpmyadmin-shapefile
php-phpmyadmin-sql-parser php-psr-cache php-psr-container
php-psr-http-factory php-psr-http-message php-psr-log php-slim-psr7
php-symfony-cache php-symfony-cache-contracts php-symfony-config
php-symfony-dependency-injection php-symfony-deprecation-contracts
php-symfony-expression-language php-symfony-filesystem
php-symfony-polyfill-php80 php-symfony-service-contracts
php-symfony-var-exporter php-tcpdf php-twig php-twig-i18n-extension
php-webmozart-assert php-zip php8.1-bz2 php8.1-mcrypt php8.1-zip

Create Symbolic Link

Create a symbolic link from the installation files to Nginx's document root directory.

sudo ln -s  /usr/share/phpmyadmin /var/www/html/phpmyadmin

Enter it into your browser's address bar to check that phpmyadmin is installed. http://yourserver-ip-address/phpmyadmin/. You should see a page similar to the below one.

images

Done!