In the basic settings for Windows XAMPP PHPMyAdmin is not protected .So it absolutely necessary to close this security hole if you start networking !To do this open a text editor and change the file "config.inc.php " the " auth_type "
Code:
$ cfg [' Servers'] [$ i ] [ ' AUTH_TYPE ' ] = ' config ' ;
$ cfg [ ' Servers ' ] [ $ i ] [ ' user ' ] = 'root ';
$ Cfg [' Servers' ] [$ i ] [' password '] = ' secret ';
This becomes:
Code:
$ cfg [ 'Servers ' ] [ $ i] [' AUTH_TYPE ' ] = ' http ';
$ cfg [ ' Servers ' ] [ $ i ] [ ' user ' ] = 'root ';
$ Cfg [ ' Servers'] [$ i ] [ ' password '] ='' ;
Now a user and a password is required before PHPMyAdmin access the MySQL server . Before, there must be a password for root in MySQL ! Optionally for http " auth_type "a cookie may be used.
Bookmarks