Wondering how to secure PhpMyAdmin in bitnami server? We can help you.

As part of our Server Management Services, we assist our customers with similar queries.

Today, let us see how our Support techs perform this task.

How to secure PhpMyAdmin in bitnami server?

Today, let us see the steps followed by our Support techs in order to perform this task.

To identify your Bitnami installation type and what approach to follow, run the command below:

test ! -f "/opt/bitnami/common/bin/openssl" && echo "Approach A: Using system packages." || echo "Approach B: Self-contained installation."

The output of the command indicates which approach (A or B) is use by the installation, and will allow you to identify the paths, configuration and commands to use in this guide.

If you would like, add an additional layer of security by enabling Apache’s authentication when accessing phpMyAdmin.

Follow these steps:

• Edit the Apache configuration file for the phpMyAdmin application and add the following lines inside the Directory block:

Please note depending on your installation type, you can find the Apache configuration file for phpMyAdmin in the following locations:

Approach A (Bitnami installations using system packages): /opt/bitnami/apache2/conf/bitnami/phpmyadmin.conf

Approach B (Self-contained Bitnami installations): /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf

AuthType Basic
AuthName phpMyAdmin
AuthUserFile "/opt/bitnami/apache2/users"
Require valid-user

• Then, change or set the phpMyAdmin access password using the following command and replacing PASSWORD with the new password:

sudo /opt/bitnami/apache2/bin/htpasswd -cb /opt/bitnami/apache2/users administrator PASSWORD

• Finally, restart Apache to have the changes take effect:

sudo /opt/bitnami/ctlscript.sh restart apache

Now, when accessing phpMyAdmin, users will prompt to log in twice: first, with the username administrator and second, with the username root.

The password for the first is the one set in the second step above.

The password for the second can obtain from the server launchpad or control panel.

[Need help with similar queries? We’d be happy to assist you]

Conclusion

In short, we saw how our Support Techs Secure PhpMyAdmin in bitnami server.