phpMyAdmin is an open-source PHP application built to manage MySQL and MariaDB database servers via the 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. Now that you can install Linux OS inside Windows via WSL, the steps below show you how to install phpMyAdmin inside Windows systems. With WSL, you can install and run a full Linux operating system inside Windows. Let’s get Windows, enable WSL, install a Linux OS, and run phpMyAdmin. Back in 2017, Windows released the original WSL version. WSL 2 is an improvement over version 1 and comes with a performance boost, full system call compatibility, and built with a new architecture that delivers features that make WSL an amazing way to run a Linux environment in Windows. If you have a machine that meets the requirements above to run WSL 2, then continue below. To get started with running phpMyAdmin on Windows with WSL, follow the steps below:

Enable WSL in Windows

To enable WSL in Windows, you will want to open the PowerShell terminal as administrator. Click on Start then begin typing PowerShell. Next, right-click the Windows PowerShell app and choose to run as administrator. When the console opens, run the commands below: After installing, you should get a success message similar to the lines below:

Enable Virtual Machine Platform

WSL 2 requires Windows 10 Virtual Machine Platform to be enabled. This is not Hyper-V. To enable the VM platform feature in Windows, run the commands below from the same PowerShell administrator’s console. If you’re using Windows 10 version lower than 2004, then use the commands below: When you’re done running the commands above, restart your computer for all the configuration changes to apply. If you don’t restart, the below command might not be recognized. After restarting your computer, login back in and launch PowerShell as administrator. Then run the commands below to configure WSL 2 as the default version of WSL.

Install Ubuntu on Windows 10

Now that WSL 2 is installed and ready to be used, open the link below to download and install a copy of Ubuntu 20.04 from the Windows store. Get Ubuntu 20.04 LTS – Microsoft Store Ubuntu 20.04 LTS on Windows allows you to use Ubuntu Terminal and run Ubuntu command line utilities including bash, ssh, git, apt, and many more. Click the Get button and install. After installing Ubuntu, you’ll want the option to launch Ubuntu from the Windows WSL environment. After launching Ubuntu, it should install and prompt you to create your account. That should do it! Some troubleshooting commands to run when you run into the issues above. These run below and try to launch the Ubuntu image again. Now that Windows 10 WSL environment is ready, continue below to install Apache, MariaDB, and PHP and configure phpMyAdmin to run. Since we’re going to be running phpMyAdmin with Apache web server, continue below to install it.

Install Apache HTTP Server

Apache is the most popular open-source web server powering the majority of websites online. To install Apache on Ubuntu, run the commands below: After installing Apache2, the commands below can be used to stop, start and restart Apache2 services. 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. http://localhost

Install MariaDB Database Server

MariaDB is a truly 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: After installing MariaDB, the commands below can be used to stop, start and restart MariaDB services. 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, log in to the database console using the commands below: Type the root password when prompted. If you see a similar screen as shown above, then the server was successfully installed.

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. 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: You can also test with a test PHP script that displays the 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 Then type the content below and save the file. Save the file. Open your browser and browse to your server hostname followed by phpinfo.php Restart Apache, then type the address and browse the file. You should see the PHP default test page.

Install phpMyAdmin

Now that you have installed Apache, MariaDB, and PHP, run the commands below to install phpMyAdmin. During the installation, you’ll be prompted to select the webserver to run with phpMyAdmin. When prompted to choose the web server, select apache2 and continue. When prompted again to allow web config-common to install a database and configure select Yes. 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 an auth_socket plugin. This plugin authenticates users who connect from the local host via a socket file without prompting or using a password. If you attempt to log on to phpMyAdmin with the MariaDB root account, you won’t be allowed. If you wish to use the root account to log on 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 the MariaDB console. Then run the commands below to change to disable mysql_native_password module. Save your changes and 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 the phpMyAdmin portal. Conclusion: 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.