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:
To enable remote access to phpMyAdmin from other hosts, follow these steps:
-
Edit the etc/extra/httpd-xampp.conf file in your XAMPP installation directory (usually, /opt/lampp).
-
Within this file, find the block below:
<Directory "/opt/lampp/phpmyadmin"> AllowOverride AuthConfig Require local ...
Update this block and replace Require local with Require all granted, so that it looks like this:
<Directory "/opt/lampp/phpmyadmin"> AllowOverride AuthConfig Require all granted ...
-
Save the file and restart the Apache server using the XAMPP control panel.
You should now be able to access phpMyAdmin from other hosts.