Secure XAMPP phpmyadmin access
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 -
// ...
);