Require password to log in to phpmyadmin setup method_PHP tutorial

Find the config.inc.php tutorial

1. Use cookie authorization mode to change 'auth_type' to 'cookie', and then modify 'blowfish_secret' to use an arbitrary string as the cookie encryption string. If there is no encryption key, the system will display "The configuration file now requires top secret Phrase password (blowfish_secret) ", the configuration file is as follows: $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['blowfish_secret'] = '44e2f5aece2855.93921574'; After modification , enter the login window
4
Web login page in http authorization mode

2. Use config authorization mode
config requires these parameters:
$cfg['Servers'][$i]['auth_type'] = 'config';
//Authorization mode $cfg['Servers'][$i]['user'] = 'root'; //mysql tutorial login user $cfg['Servers'][$i]['password'] = '12345';
//mysql login user password

Change config.inc to

$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
Note, it’s not http but cookie! ! !

3. Use http authorization mode

$cfg['Servers'][$i]['auth_type'] = 'http';

Login window in http authorization mode

Note: If the mysql server uses version 4.1 or above, and the client connection uses mysql 4.1 or lower, be sure to use the OLD_PASSWORD function when setting the password for the user, for example:
mysql > SET PASSWORD = OLD_PASSWORD('12345')
mysql > /G
Appendix: (The following content is written by myself) In addition to the above three methods that come with phpmyadmin, you can also use apache configuration to restrict login. Place an .htaccess file in the phpmyadmin directory and specify the password record file to be used. Then use htpasswd to generate a password and save it in the password record file (the content of the file is encrypted, use the method htpasswd /etc/php_passwd username).
Contents in httpd.conf: phpmyadmin's directory"> AllowOverride AuthConfig
Contents of .htaccess file
authtype basic authuserfile /etc/php_passwd authname information require valid-user
We can see that the content in the /etc/php_passwd file is similar to this:
username:2Y2CD6nfJuwL6

More detailed tutorial

Open the libraries file in phpMyAdmin, find config.default.php and open it.

Find $cfg['servers'][$i]['user'] = ' ', add 'root' to ' '

Find $cfg['servers'][$i]['password'] = ' ', add '123456' to ' ';

The modification in these two places is to add the user name and password of the Mysql just installed. Readers can modify it by themselves.

This is the configuration file and needs to be modified.
config.inc.php

/* $Id: config.sample.inc.php 9689 2006-11-10 20:05:49Z nijel $ */

// vim: expandtab sw=4 ts=4 sts=4:

/**

* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki .
*/

/*

* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'afafafaf'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*

* Servers configuration
*/
$i = 0;

/*

* First server
*/
$i++;
/* Authentication type */
$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';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = ''; //Username
$cfg['Servers'][$i]['controlpass'] = '';//Password
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/*

* End of servers configuration
*/

/*

* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

http://www.bkjia.com/PHPjc/632288.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/632288.htmlTechArticleFind config.inc.php Tutorial 1. Use cookie authorization mode to change 'auth_type' to 'cookie', Then modify 'blowfish_secret' to use an arbitrary string as the cookie's encrypted string, if not...