Configuration of the 1\xampp phpMyAdmin
1. Open "Path/phpmyadmin/libraries/config.default.php" to find the relevant item and modify it to the following:
$cfg [' pmaabsoluteuri '] = ' http://218.206.205.35/phpmyadmin/';
$cfg [' blowfish_secret '] = ' tbkt '; [87] Passphrase
$cfg [' Servers '] [$i] [' host '] = $_cookie["Mysqlhost"]; Host Address
$cfg [' Servers '] [$i] [' port '] = $_cookie["Mysqlport"]; [115] Port number
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; [186] Enable cookies
$cfg [' Servers '] [$i] [' user '] = $_cookie["Pma_username"]; User name
$cfg [' Servers '] [$i] [' password '] = $_cookie["Pma_password"];
$cfg [' Servers '] [$i] [' nopassword '] = true; [250] password allowed is empty
$cfg [' Servers '] [$i] [' allownopassword '] = true; [422] Password allowed is empty
$cfg [' logincookievalidity '] = 86400; [676] Login timeout setting, default is 1440. 86400 for one day
$cfg [' verbosemultisubmit '] = true; [721] allows multiple management
$cfg [' allowarbitraryserver '] = true; [721] allows multiple management
$cfg [' exectimelimit '] = 0;
$cfg [' logincookierecall '] = false;
$cfg [' logincookievalidity '] = 60;
2\ modifying the MySQL root user password
After installing XAMPP, if you modify the MySQL root user password, phpMyAdmin will not be able to log in and need to update the phpMyAdmin configuration.
phpMyAdmin file directory in the LAMPP installation directory, a total of two key configuration files, phpmyadmin/config.inc.php and phpmyadmin/libraries/config.default.php.
Where config.default.php is the default configuration of the system, no modifications are required, but the details of the various configurations, available options, and the various options are worth finding.
After modifying the MySQL password, the file to be updated is the config.inc.php file, confirming the two configurations:
$cfg [' Servers '] [$i] [' auth_type '] = ' config '; Get the password from the configuration file, also can be paired with a cookie, HTTP, etc. see the default file meaning.
$cfg [' Servers '] [$i] [' password '] = ' XXXXX '; Your newly-configured password
The MySQL default root password for the newly installed XAMPP integration environment is empty 1. First log in with a blank password from phpMyAdmin, and select the user table in MySQL data
2. Use the SQL statement to modify the root user's password update user set password = password (' root ') where user = ' root ';
3. Modify the phpMyAdmin configuration file, use the cookie login method, change the username and password to root/root, and then restart the MySQL service.
XAMPP phpmyadmin MySQL Configuration