Documentation

Enable Remote Access to phpMyAdmin

XAMPP includes phpMyAdmin, an open-source, browser-based tool for managing MySQL/MariaDB database servers. By default, for security reasons, phpMyAdmin is configured to only accept connections from the host on which XAMPP is installed. Attempting to access phpMyAdmin from any other host will produce the error below:

image1

To enable remote access to phpMyAdmin from other hosts, follow these steps:

  1. Edit the etc/extra/httpd-xampp.conf file in your XAMPP installation directory (usually, /Applications/XAMPP).

  2. Within this file, find the block below:

    <Directory "/Applications/XAMPP/phpmyadmin">
      AllowOverride AuthConfig
      Require local
      ...

    Update this block and replace Require local with Require all granted, so that it looks like this:

    <Directory "/Applications/XAMPP/phpmyadmin">
      AllowOverride AuthConfig
      Require all granted
      ...
  3. Save the file and restart the Apache server using the XAMPP control panel.

You should now be able to access phpMyAdmin from other hosts.