KwikSteps

StepsSetup phpMyAdmin (MySQL Client) on Ubuntu on windows 10

by

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.

Article Image

Requirements

  • Windows 10 64-bit
  • Windows 10 Anniversary Update
  • Bash on Ubuntu on Windows feature
  • MySQL server
  • PHP
  • Apache

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:

Tools and commands used

  • Bash on Ubuntu on Windows shell
  • apt-get shell command
  • service command
  • php5enmod command
  • Browser
  • nano text editor

Step 1: Run the Bash on Ubuntu on Windows shell

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:

su root

If prompted to enter the password, please do so.

Step 2: Make sure that MySQL server is running

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

Step 3: Download and install phpMyAdmin using apt-get

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.

  • The first page will ask you if you want to configure the database for phpMyAdmin. Choose “Yes” and hit enter as shown below:
Article Image
  • The second page will ask you to provide the root password. Please type the root password and hit enter.
  • The third page will ask you to provide a password for the phpMyAdmin interface. Please type the password and hit enter.

Read carefully

  • The fourth page will ask you to choose the web server that should be automatically configured to run phpMyAdmin.

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:

Article Image

Step 4: Enable php5-mcrypt extension using the php5enmod command

The php5-mcrypt extension is required by the phpMyAdmin interface. To enable it, use the following command:

php5enmod mcrypt

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

Step 5: Test phpMyAdmin using a browser

To test and check if the installation is successful is by launching a browser of your choice and point it to the following address:

http://localhost/phpmyadmin

Step 6: Configure phpMyAdmin by editing phpmyadmin.conf file

If you would like to change the apache2 default configuration of phpMyAdmin, edit the following file using the nano editor:

nano /etc/apache2/conf-enabled/phpmyadmin.conf

If you would like to change the default phpMyAdmin configuration, edit the following file using the nano editor:

nano /etc/phpmyadmin/config.inc.php
Comments (1)
Load comments
Post your comment
*Name:
Email:
*Comment:
Post Comment
logo203X28
Copyright © 2017
KwikSteps
- All Rights Reserved.
Thank you!
Namecheap.com