This post shows students and new users how to install and configure phpMyAdmin on Windows 11 Windows Subsystem for Linux (WSL).
phpMyAdmin is an open source PHP application built to manage MySQL and MariaDB databases servers via intuitive web interface. All database tasks and queries can be handled by phpMyAdmin.
With phpMyAdmin, you can manage MySQL databases, user accounts and privileges, execute SQL queries and statements, import and export database content and much more.
You can now install and run phpMyAdmin on directly from Windows desktop or server via Windows Subsystem for Linux (WSL) without installing third party apps or using a virtual machine.
Back in 2017, Microsoft released WSL and later WSL2 that lets developers run a GNU/Linux environment, including most command-line tools, utilities, and applications directly in Windows without setting up a virtual machine or dual-boot.
WSL2 is the new and improved version comes with performance boost, full system call compatibility, and built with a new architecture and that delivers features that make WSL an amazing way to run a Linux environment in Windows.
To get started with running phpMyAdmin on Windows with WSL, follow the steps below:
Install Windows Subsystem for Linux in Windows 11
To enable WSL in Windows, you will want to open the Command Prompt as administrator. Click on Start then begin typing Command Prompt.
Next, right-click Command Prompt app and choose to Run as administrator.
When the console opens, run the commands below to install Windows Subsystem for Linux (WSL):
Wait for WSL to be installed.
After installing, you should get a success message similar to the lines below:
Installing: Virtual Machine Platform Virtual Machine Platform has been installed. Installing: Windows Subsystem for Linux Windows Subsystem for Linux has been installed. Downloading: WSL Kernel Installing: WSL Kernel WSL Kernel has been installed. Downloading: GUI App Support Installing: GUI App Support GUI App Support has been installed. Downloading: Ubuntu The requested operation is successful. Changes will not be effective until the system is rebooted.
Restart your computer.
WSL should be installed and ready to use. When you want to update, simply run the commands below:
Install Specific Linux distro on Windows 11
Now that WSL is installed, you can now install Linux distro of your choice. To list the available distributions to install, simply run the commands below:
wsl --list --online
You should then see all available distributions that can be installed on WSL.
NAME FRIENDLY NAME Ubuntu Ubuntu Debian Debian GNU/Linux kali-linux Kali Linux Rolling openSUSE-42 openSUSE Leap 42 SLES-12 SUSE Linux Enterprise Server v12 Ubuntu-16.04 Ubuntu 16.04 LTS Ubuntu-18.04 Ubuntu 18.04 LTS Ubuntu-20.04 Ubuntu 20.04 LTS
To install a Linux distribution from the list above, simply run the commands below using the distribution name. For example, to install Ubuntu 20.04, run the commands below:
wsl --install -d ubuntu-20.04
You should then get a message that the distribution is installed.
Downloading: Ubuntu 20.04 LTS Installing: Ubuntu 20.04 LTS Ubuntu 20.04 LTS has been installed. Launching Ubuntu 20.04 LTS.
After installing, you should get a Ubuntu command console with setup details.
Installing, this may take a few minutes. Please create a default UNIX user account. The username does not need to match your Windows username. For more information visit: Enter new UNIX username: Richard New password: Retype new password: passwd: password updated successfully Installation successful! To run a command as administrator (user "root"), use "sudo <command>". See "man sudo_root" for details. Welcome to Ubuntu 20.04 LTS (GNU/Linux 4.4.0-22000-Microsoft x86_64)
Some troubleshooting commands to run when you run into issues.
wsl --set-default-version 1 bcdedit /set hypervisorlaunchtype auto start
Now that Ubuntu Linux is installed and ready to use, continue below to install the LAMP server to run WordPress on. First, install Apache HTTP Server.
Install Apache HTTP Server
Apache is the most popular open source web server powering majority of the websites online.
To install Apache on Ubuntu, run the commands below:
sudo apt update sudo apt install apache2
After installing Apache2, the commands below can be used to stop, start and restart Apache2 services.
sudo service apache2 stop sudo service apache2 start sudo service apache2 restart
To validate that Apache is installed and functioning, open your web browser and browse to the server’s hostname or IP address.
You should get a test page if every works.
Install MariaDB Database Server
MariaDB is a true open source database server you can run with your projects. It is fast, secure and the default server for almost all Linux.
To install MariaDB, run the commands below:
sudo apt-get install mariadb-server mariadb-client
After installing MariaDB, the commands below can be used to stop, start and restart MariaDB services.
sudo service mysql stop sudo service mysql start sudo service mysql restart
Next, run the commands below to secure the database server with a root password if you were not prompted to do so during the installation.
When prompted, answer the questions below by following the guide.
- Enter current password for root (enter for none): Just press the Enter
- Set root password? [Y/n]: Y
- New password: Enter password
- Re-enter new password: Repeat password
- Remove anonymous users? [Y/n]: Y
- Disallow root login remotely? [Y/n]: Y
- Remove test database and access to it? [Y/n]: Y
- Reload privilege tables now? [Y/n]: Y
To verify and validate that MariaDB is installed and working, login to the database console using the commands below:
sudo mysql -u root -p
Type the root password when prompted.
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 46 Server version: 10.3.29-MariaDB-0ubuntu0.20.04.1 Ubuntu 20.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
If you see a similar screen as shown above, then the server was successfully installed.
PHP and Related Modules
PHP is a general-purpose scripting language that enables the LAMP and LEMP stack and is required by phpMyAdmin.
To install PHP and recommended modules, run the commands below.
sudo apt install php libapache2-mod-php php-common php-mysql php-gmp php-curl php-intl php7.4-mbstring php-xmlrpc php-gd php-xml php-cli php-zip
That should get PHP installed with recommended PHP modules that you can run with many PHP based applications.
To validate that PHP is installed, run the commands below:
You should see an output like the one below:
PHP 7.4.3 (cli) (built: Oct 6 2020 15:47:56) ( NTS ) Copyright (c) The PHP Group Zend Engine v3.4.0, Copyright (c) Zend Technologies with Zend OPcache v7.4.3, Copyright (c), by Zend Technologies
You can also test with a test php script and displays installed version as well as related modules that are enabled or disabled.
To do that, run the commands below to create a php test file called phpinfo.php
sudo nano /var/www/html/phpinfo.php
Then type the content below and save the file.
<?php phpinfo( ); ?>
Save the file.
Open your browser and browse to your server hostname followed by phpinfo.php
Restart Apache, then type the address and browse to the file.
You should see PHP default test page.
Now that you have installed Apache, MariaDB and PHP, run the commands below to install phpMyAdmin.
sudo apt install phpmyadmin
During the installation, you’ll be prompted to select the web server to run with phpMyAdmin.
When prompted to choose the webserver, select apache2 and continue.
+------------------------+ Configuring phpmyadmin +-------------------------+ | Please choose the web server that should be automatically configured to | | run phpMyAdmin. | | Web server to reconfigure automatically: | | | | [*] apache2 | | [ ] lighttpd | | | <Ok> | +---------------------------------------------------------------------------+
When prompted again to allow debconfig-common to install a database and configure select Yes.
+------------------------+ Configuring phpmyadmin +-------------------------+ | | | The phpmyadmin package must have a database installed and configured | | before it can be used. This can be optionally handled with | | dbconfig-common. | | | | If you are an advanced database administrator and know that you want to | | perform this configuration manually, or if your database has already | | been installed and configured, you should refuse this option. Details | | on what needs to be done should most likely be provided in | | /usr/share/doc/phpmyadmin. | | | | Otherwise, you should probably choose this option. | | | | Configure database for phpmyadmin with dbconfig-common? | | | | <Yes> <No> | | | +---------------------------------------------------------------------------+
Enter a password and confirm for phpMyAdmin to register with the database, then select OK and complete the installation.
MySQL and MariaDB come with a feature that provides root authentication via a auth_socket plugin.
This plugin authenticates users who connect from the localhost via socket file without prompting or using a password. If you attempt to logon to phpMyAdmin with the MariaDB root account, you won’t be allowed.
If you wish to use the root account to logon to phpMyAdmin, then use the steps below. To fix that, you’ll need to change the default authentication mechanism from auth_socket to mysql_native_password.
Login back into MariaDB console.
Then run the commands below to change to disable mysql_native_password module.
USE mysql; UPDATE user SET plugin='' WHERE user="root";
The save your changes and exit:
FLUSH PRIVILEGES; EXIT;
Restart Apache and browse to phpMyAdmin web portal using the URL:
That will bring up the login page where you should be able to do so with the root account.
Begin managing your database server from phpMyAdmin portal.
This post showed you how to install phpMyAdmin in Windows WSL. If you find any error above, please use the comment form below to report.