
Visit the phpMyAdmin download page to grab the latest version of phpMyAdmin. The stable version of phpMyAdmin at the time this article was written: phpMyAdmin 4.3.11.1 (released ). Step 2: Download Latest Version of phpMyAdmin In this case, we’ll need to put the phpMyAdmin files in /var/www/html. We need to find Apache’s DocumentRoot so we know where to place our phpMyAdmin files: $ grep DocumentRoot /etc/apache2/sites-available/nf
#SETUP PHPMYADMIN UBUNTU 20.04 INSTALL#
While it’s not recommended for production servers, because you have to manually ensure your install of phpMyAdmin is kept up-to-date, you can also install phpMyAdmin from source. Now if you try to access the phpMyAdmin login, you’ll get the. htaccess credentials, you can create additional secure users with: sudo htpasswd /etc/phpmyadmin/.htpasswd anotheruser If for some reason you wanted to give others access to the phpMyAdmin login screen but didn’t want them using your. Now we can create a secure user for our phpMyAdmin application with the command: $ sudo htpasswd -c /etc/phpmyadmin/.htpasswd phpmyadmin If you don’t already have this installed, use the following: sudo apt-get install apache2-utils htpasswd File for Authenticationįirst we need the htpasswd utility.

Now that we’ve enabled overrides for our phpMyAdmin application from Apache, we need to actually create an override with an. Restart Apache so our changes take affect: sudo service apache2 restart Step 3: Create an.

Step 2: Restart Apache to Accept Config Changes We want to edit the phpMyAdmin Apache config that was created earlier: sudo vi /etc/apache2/conf-available/nfĪdd AllowOverride “ALL” directive below the DirectoryIndex: We can easily secure our phpMyAdmin installation by using Apache’s built-in. Naturally, because phpMyAdmin is such a common application installed on many web servers, it is a popular target for unauthorized access attempts.
