Secure XAMPP phpmyadmin access

3:44 AM Hendry 0 Comments

1. Navigate to \xampp\phpmyadmin
2. Open up config.inc.php
3. Append the configuration below
4. Modify either deny or allow

/*
 *  phpMyAdmin does no user management and will not cross-check the MySQL account's host with the incoming connection's ip/host
 */
$cfg['Servers'][$i]['AllowDeny']['order'] = 'deny,allow';
$cfg['Servers'][$i]['AllowDeny']['rules'] = array(
    // deny everyone by default
    'deny % from all',

    // allow all users from the local system
    'allow % from localhost',
    'allow % from 127.0.0.1',
'allow % from 192.168.0.16',
    'allow % from 139.195.8.205',
'allow % from ::1',

    // add more usernames and their IP (or IP ranges) here -
    // ...

);