Configuration phpmyadmin ubuntu install#

Restart Apache to load the new configuration file. $ sudo ln -s /etc/phpmyadmin/nf /etc/apache2/conf-available/nf

Use the a2enconf command to enable the new configuration file created by the phpMyAdmin. Repeat the same password to finalize the installation process. When prompted to configure a database for your phpMyAdmin package, choose Yes and press ENTER to proceed.Įnter a strong password for the phpMyAdmin package. When prompted to choose a web server, hit TAB, then ENTER to select apache2 as shown in the screenshot below.

Configuration phpmyadmin ubuntu install#

$ sudo apt install -y php-json php-mbstring php-zip php-gd php-curl Make sure your system has the following required PHP extensions. SSH to your Ubuntu server and update the package repository index. To proceed with this phpMyAdmin setup, make sure you have the following: In this tutorial, you'll install, configure and secure the phpMyAdmin package with a LAMP stack on your Ubuntu 20.04 LTS server.

With its intuitive web interface, phpMyAdmin allows you to import and export data in various formats, including CSV and plain text SQL, making it one of the best GUI-based database management software. You can use it to easily manage databases, tables, indices, users, permissions, and more, without touching the command-line interface. PhpMyAdmin is a web-based open-source database administration tool for MySQL and MariaDB servers.