How to install phpMyAdmin on Windows 10

In this tutorial you can learn how to install phpMyAdmin on Windows 10. PhpMyAdmin is an open-source software, designed to handle the management of MySQL databases through a graphical user interface.

Prerequisites

To install and use phpMyAdmin a local web server must be configured and running properly. If you don’t have a local web server yet, follow our tutorial: How to setup Apache, PHP and MySQL on Windows 10.

In this tutorial we will use

  • Apache 2.4 web server
  • MySQL 5.7.1
  • PHP 7.4

Installation steps

phpmyadmin windows directory
  • Rename config.sample.inc.php to config.inc.php
  • Open the config.inc.php in a text editor and find this line
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
  • Add a value of your choice (min. 32 characters long), for example
$cfg['blowfish_secret'] = 'HUtJc4w3PJH8j2IpIHO391kPhAQrsBgy'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
  • Save the config.inc.php file
  • Make sure you have mbstring and mysqli PHP extensions enabledopen the php.ini file located in your php folder (C:\phpxx by default, where xx is the version number, e.g.: C:\php74)
  • find the ;extension=mbstring line and remove the semicolon (;) from the beginning
extension=mbstring
  • do the same for the line ;extension=mysqli
  • extension=mysqli
  • save the php.ini file
  • restart Apache service in Services (Windows key + R and type services.msc)
apache restart
  • Open http://localhost/phpmyadmin/ in your browser, log in with your root username and password
phpmyadmin login
  • There will be a message at the bottom of the screen which says that the configuration storage is not completely configured. PhpMyAdmin needs a database to work. To configure the storage, click Import at the top of the screen and select the create_tables.sql file from the C:\Apache24\htdocs\phpMyAdmin\sql directory
phpmyadmin import
  • Click Go at the bottom of the screen and the warning message should be gone

Do you have a project for us?

Contact us

Our Services

WEB DESIGN AND DEVELOPMENT

From raw idea to a scalable product
Each website we develop is truly unique, tailor-made for your brand, product or company.

Learn more »

WORDPRESS & WOOCOMMERCE

Custom online-store, theme and plugin development
GoWild Digital leverages the flexibility of the WordPress platform to develop websites that can be easily maintained and upgraded.

Learn more »

TECHNICAL SEO AUDIT

A health check of your website
Our Technical SEO audit identifies technical errors with your website that can be hindering your performance and visibility.

Order now »

WORDPRESS SPEED OPTIMIZATION

Enhance your site’s user experience and rankings
Website speed optimization service that can help your website load at top speeds and generate more conversions.

Order now »

AD-HOC SUPPORT AND MAINTENANCE

For a fixed price
Purchase a block of support minutes to complete any tasks needed. Minutes purchased never expire.

Order now »

WEBSITE MIGRATION

We can help you to migrate your website to your new web hosting
Let us take on the heavy lifting of your next website migration to reduce your stress and to migrate your site efficiently and effectively

Order now »

Update Gone Wrong

An update broke your WordPress site?
Let us help you! Our service provides you with the fix of one error to get your WordPress website back up and running.

Order now »

Repair Hacked Website

Site hacked?
We’ll restore your website fast to help limit the downside. If it gets reinfected in the next 30 days, we fix it for FREE again.

Order now »

Quick Website Repair

Broken WordPress or PHP based website?
Our service provides you with the fix of one error to get your website back up and running.

Order now »

Our Work

Green Guide Budapest

Green Guide Budapest

greenguide.hu
Web design: Mimma Nosek (Behance)
UI/UX mentor: Júlia Tóth (Behance, Dribble)

Trilla

Trilla

trillafesztival.hu

Web design: Anuri Design Studio (Website)

Barber Bay

Barber Bay

barberbay.hu

Web design: Endre Gömöri (LinkedIn)

MOST

MOST

mostmusic.eu

Web design: Anuri Design Studio (Website)

Hungarian World Music Guide

Hungarian World Music Guide

hungarianworldmusicguide.com

Web design: Anuri Design Studio (Website)

Have a question?