phpMyAdmin has 3 modes of authorization: 1. Cookies: Displays a Web login page, enters the MySQL username and password, and then enters the admin interface.
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';/* Server parameters */$cfg [' Servers '] [$i] [' host '] = ' localhost '; $cfg [' Servers '] [$i] [' connect_type '] = ' TCP '; $cfg [' Servers '] [$i] [' compress '] = false;/* Select mysqli If your server has it */$cfg [' Servers '] [ $i [' extension '] = ' mysql '; $cfg [' Servers '] [$i] [' allownopassword '] = false;
2. http: Display 1 Windows login box, enter MySQL username and password, and enter management.
$cfg [' Servers '] [$i] [' auth_type '] = ' http ';/* Server parameters */$cfg [' Servers '] [$i] [' host '] = ' localhost '; $cfg [' Servers '] [$i] [' connect_type '] = ' TCP '; $cfg [' Servers '] [$i] [' compress '] = false;/* Select mysqli If your server has it */$CF g[' Servers ' [$i] [' extension '] = ' mysql '; $cfg [' Servers '] [$i] [' allownopassword '] = false;
3. config: the MySQL user name and password directly into the config.inc.php, do not display the login interface, directly into the management interface. The config mode requires these parameters, as follows: $cfg [' Servers '] [$i] [' auth_type '] = ' config '; $cfg [' Servers '] [$i] [' user '] = ' root '; $cfg [' Servers '] [$i] [' password '] = ' root '; The configuration file for phpMyAdmin is named Config.inc.php, and the config.inc.php of each version is modified as follows: 2.6 Previous version: Change config.inc.sample.php to config.inc.php 2.7 Version: Change config.default.php to config.inc.php 2.8 version: Generate configuration file with configuration script '/script/setup.php ', copy the generated file, save manually as config.inc.php
How to set the password and change the password in phpMyAdmin config.inc.php