#INSTALL PHPMYADMIN UBUNTU SECURED HOW TO#

It’s separate from the mysql user/pass we’ve created earlier, which it will prompt right after. This means, when you browse to the site for phpmyadmin, it will popup a login box, the user/pass combo is what we’ve just created. htpasswd file: sudo nano /usr/share/phpmyadmin/.htaccessĪnd then after saving that type: sudo htpasswd -c /etc/phpmyadmin/.htpasswd phpmyadmin Sudo nano /etc/apache2/conf-available/nfĪppend allowoverride directive: AllowOverride AllĪnd restart apache again, sudo service apache2 restart Next, let’s work on the security, phpmyadmin is a target, so it’s smart to add an extra layer of security with. Give it your mysql root password, and then add a phpmyadmin user, I will go with phpmyuser CREATE USER ' IDENTIFIED BY ' password' Īnd then grant it the correct permissions: GRANT ALL PRIVILEGES ON *.* TO ' WITH GRANT OPTION Login to your mysql server: mysql -u root -p

#INSTALL PHPMYADMIN UBUNTU SECURED HOW TO#

Note: In a previous blog we’ve changed the way root can use mysql, the auth_socket got changed to mysql_native_passowrd, we assume that’s the case. In this section we learn how to install and secure phpmyadmin on ubuntu.

Next, we have to add user authentification, and work on the security a little bit. Make sure to select Apache from the list, press ok, give it a password for phpmyadmin, and let the installation complete.Īnd now restart the web server: sudo service apache2 restart

Make sure your server is up to date, you can apt update, and apt upgrade first, then: sudo apt install phpmyadmin php-mbstring php-gettext In this section we learn how to install and secure phpmyadmin on ubuntu. If you do wish to install it, continue reading, but take some security precautions. Once you have https configured on your server, and you have a MySQL server installed, it might be desirable to install phpmyadmin, this is a php web interface solution to help you manage your mysql databases, users, etc.įor security reasons: don’t install it.

Install phpmyadmin ubuntu secured