The phpMyAdmin is a free MySQL database management and administration client based on a web-application written in PHP. It allows the user to fully access the MySQL server through a web interface. In this tutorial, we will show you how to install it using Bash on Ubuntu on Windows feature that came with the Windows 10 Anniversary Update.
If you are not running the Windows 10 Anniversary Update or Windows 10 Creator Update, please follow one of the following tutorials:
If you are running Windows 10 Anniversary Update but haven’t installed the Bash on Ubuntu on Windows feature, please follow the following tutorial:
If haven’t installed the Apache Server yet, please the following tutorial:
If haven’t installed PHP for Apache Server yet, please the following tutorial:
If haven’t installed MySQL server yet, please the following tutorial:
To do this, click on start (or press the Windows key) and type “Bash on Ubuntu on Windows” then click on it to start using the shell.
If you are not running bash as root, please type:
If prompted to enter the password, please do so.
You can check if MySQL server is running by typing the following command:
service mysql status
You can also check if MySQL server is running by typing the following command and supplying your MySQL root password after you hit enter:
mysqladmin status -u root -p
Remember that you need to have all the requirements mentioned above in the requirements sections in order to be able to install phpMyAdmin. To install it, you need to use the Linux command apt-get as shown below:
apt-get install phpmyadmin
The installation will show you the needed disk space for the installation and ask you if you want to continue. Type “Y” and hit enter.
During the installation, a package configuration pages will appear.
Make sure you select the apache2 option by using the SPACE Key. The option selected will have the Asterix sign (*). Use the TAB key to highlight the OK button. Make sure the page will look like what is shown below:
The php5-mcrypt extension is required by the phpMyAdmin interface. To enable it, use the following command:
The final step of installing phpMyAdmin is to restart the apache2 server for the configuration added to the apache2 server to take effect. Type the following to restart apache2:
service apache2 restart
To test and check if the installation is successful is by launching a browser of your choice and point it to the following address:
If you would like to change the apache2 default configuration of phpMyAdmin, edit the following file using the nano editor:
If you would like to change the default phpMyAdmin configuration, edit the following file using the nano editor: