#Ubuntu install phpmyadmin 20.04 how to
#Ubuntu install phpmyadmin 20.04 update
#Ubuntu install phpmyadmin 20.04 manual
#Ubuntu install phpmyadmin 20.04 upgrade

First, update the APT packages with the following command: sudo apt update PhpMyAdmin is available in Ubuntu 20.04 default repository. When you are done with these requirements you can start to install phpMyAdmin on Ubuntu 20.04.

#Ubuntu install phpmyadmin 20.04 how to

for this, you can check our article about How to secure Apache with Let’s Encrypt on Ubuntu 20.04.

Also, you need to have a domain configured with an SSL/TLS certificate.

you can visit this article about How to set up Apache virtual hosts.

You need to set up Apache virtual hosts for your domain.

you can visit our article about how to install the LAMP stack on ubuntu 20.04. to this, you can check the Initial server setup article for Ubuntu 20.04.

How to Install and Secure phpMyAdmin on Ubuntu 20.04īefore you start to install and secure phpMyAdmin on Ubuntu 20.04 you need some requirements first. PhpMyAdmin is a free web application that provides a convenient GUI for working with the MySQL database management system. In other words, create an admin user for admirer as follows (again type these on on your mysql/mariadb server).In this article, we want to teach you How to Install and Secure phpMyAdmin on Ubuntu 20.04. Next, you need to make sure database permissions and password are correct, otherwise admire would not be able to connect to your database server. See UFW on Ubuntu 20.04 LTW page for detailed information. Sudo ufw allow from 10.105.28.9 to 172.16.3.1 port 3306 proto tcp comment 'allow mysql access for Adminer/Apache IP' Say Apache/adminer is running on the host having IP 10.105.28.9 address and database server is at 172.16.3.1:3306, then allow access using the ufw (type command on mysql/mariadb server):

Now all you have to do is provide database type (MySQl, PGSQL), server IP/hostname, database username/password, and database name to login and manage the database: You can access the Adminer app using the following URL format: The default config file is located at /etc/apache2/conf-enabled/nf and viewed using the cat command: Now all you have to do is restart or reload the Apache 2 server, enter: To activate the new configuration, you need to run: To activate adminer app run any one of the following a2enconf command # To re-enable PHP in user directories comment the following lines

# Running PHP scripts in user directories is disabled by default # Deny access to files without filename (e.g. # only in specific virtual host or directory # To re-enable it 's recommended to enable access to the files # Deny access to raw php sources by default SetHandler application/x-httpd-php-source LoadModule php7_module /usr/lib/apache2/modules/libphp7.4.so Use the cat command to verify that PHP 7.4 module is enabled:Ĭat /etc/apache2/mods-enabled/php7.4.

#Ubuntu install phpmyadmin 20.04 manual

For other web servers, you need to perform manual configurations. Hence, apt installed PHP and automatically configured it too. Please note that apart from Apache PHP required to run Adminer. Installing Adminerįirst update the system using the apt command/ apt-get command and then install Adminer software: Now that Apache web server installed and running let us get our hands dirty by installing Adminer. Here is how to install Apache 2 on Ubuntu 20.04 LTS. Obviously, you need Apache or any other web server installed.

Enable configuration, run: sudo a2enconf adminer.

Install Adminer by typing the sudo apt install adminer command.

Make sure Apache server installed and configured on Ubuntu.

#Ubuntu install phpmyadmin 20.04 upgrade

Update your Ubuntu server running sudo apt update & sudo apt upgrade.Procedure to install Adminer on Ubuntu 20.04 Linux server