access-phpmyadmin-remotely.pdf

(33 KB) Pobierz

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:

1. Edit the

apache/conf/extra/httpd-xampp.conf

file in your XAMPP installation directory (usually,

C:\xampp).

2. Within this file, find the block below:

AllowOverride AuthConfig

Require local

...

Update this block and replace

Require local

with

Require all granted,

so that it looks like this:

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.