Protect phpmyadmin with http basic auth

Community Support
1

Hi,
I’d like to protect phpmyadmin with http basic auth.
So what was done:

  1. I added to file /etc/phpmyadmin/apache.conf
    after line <Directory /usr/share/phpmyadmin> 
AuthType Basic
AuthName "Restricted Access"
AuthUserFile /usr/share/phpmyadmin/passwd
Require valid-user

  1. After that new password was generated
    htpasswd -c /usr/share/phpmyadmin/passwd user

  2. Configuration test
    apachectl configtest

  3. Apache was restarted
    systemctl restart apache2 && systemctl status apache2

As a result I don’t see authorization window. Can anybody please help me, where is my error?

2

/etc/phpmyadmin/apache.conf is not loaded

Use /etc/apache2/conf.d/conf.d/phpmyadmin.conf instead

3

Great! Thanks, now it works as it should!

4

Please be aware that we sometimes renew the config file

For example 1.4.15 release …

5

So update process will overwrite config. Right?

6

Usually we don’t overwrite the phpmyadmin config how ever in this case due to some security “remarks” it makes for us easier to overwrite 1 config file then sed in all the changes.