phpMyAdmin Configure login username and password tutorial

The phpmyadmin configuration file is in the config.default.php under Libraries , the main configuration is as follows:

In general, if you have MySQL and phpMyAdmin on the same server, the hostname is directly localhost

The code is as follows	Copy Code
$cfg [' Servers '] [$i] [' host '] = ' localhost ';

Then you have to configure the MySQL username and password:

The code is as follows	Copy Code
$cfg [' Servers '] [$i] [' user '] = ' root '; $cfg [' Servers '] [$i] [' password '] = * * *;

There is no need for this basic configuration, then upload the phpMyAdmin to the server root directory, with

http://website domain name/phpmyadmin/access

Some other methods

D. Authentication Methods

The code is as follows	Copy Code
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';

Here are four modes to choose from, Cookie,http,http,config
Config mode is to enter the phpMyAdmin access URL can be directly entered, without entering a username and password, is not safe, do not recommend use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data username and password to authenticate, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
I personally suggest: whether local or online, are recommended to set cookies, security first.

E. Phrase password (blowfish_secret) settings

The code is as follows	Copy Code
$cfg [' blowfish_secret '] = ';

If the authentication method is set to a cookie, you need to set the phrase password, set why the password, it is up to you, but you cannot leave it blank, otherwise you will be prompted for error when you log in phpMyAdmin
F. Setting the default language and encoding
Find

The code is as follows	Copy Code
$cfg [' defaultlang '] = ' en ';

in phpMyAdmin, there are four types of logins in total

Config: Directly enter phpMyAdmin remote login address, as long as the user name password in the configuration file can be set.

http: Pop-up dialog box, enter user name and password

Signon: Similar to the page jump login mode, at the same time need to set $cfg[' Servers ' [$i] [' Signonurl '], when you enter the phpMyAdmin remote login address will automatically jump to the Signonurl set URL.

Cookie: That is, the phpMyAdmin configuration when the login method.

Now that the entire phpmyadmin3 installation and configuration is complete, you can experience the new features of phpMyAdmin new version.