PhpMyAdmin user name and password configuration tutorial

This article introduces how to configure the mysql logon management password in phpmyadmin. Next, I will introduce you to users using the root user as an instance. For more information, see. the phpMyAdmin configuration file is in c... this article introduces how to configure the mysql logon management password in phpmyadmin. Next, I will introduce you to users using the root user as an instance. For more information, see.

The phpMyAdmin configuration file is in config. default. php under libraries. The main configuration is as follows:

In general, if your mysql and phpmyadmin are placed on the same server, the host name will use localhost directly. the code is as follows:

$ Cfg ['servers'] [$ I] ['host'] = 'localhost ';

Then you need to configure the mysql User name and password. the code is as follows:

$ Cfg ['servers'] [$ I] ['user'] = 'root ';

$ Cfg ['servers'] [$ I] ['password'] = *****';

These basic configurations are not required for the moment. then, upload phpMyAdmin to the root directory of the server and use

Http: // website domain name/phpMyAdmin/access.

Other methods

D. authentication method,The code is as follows:

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

There are four modes available here: cookie, http, HTTP, config.

In config mode, you can directly access the phpmyadmin access url without entering the user name and password. it is insecure and is not recommended.

When this option is set to cookie, http, or HTTP, you need to verify the data username and password to log on to phpmyadmin. The details are as follows.

The PHP installation mode is Apache, and http and cookie can be used;

The PHP installation mode is CGI and cookie can be used.

My personal suggestion:We recommend that you set it as a cookie on both local and network.

E. set the phrase password (blowfish_secret). The code is as follows:

$ Cfg ['blowfish _ secret'] = '';

If the authentication method is set to cookie, you need to set the phrase password and set the reason for the password. it is up to you to decide, but you cannot leave it blank. Otherwise, an error will be prompted when you log on to phpmyadmin.

F. set the default language and encoding.

The code is as follows:

$ Cfg ['defaultlang '] = 'zh ';

Phpmyadmin provides four logon methods.

Config:Directly enter the phpmyadmin remote logon address. you only need to set the user name and password in the configuration file.

Http:In the dialog box that appears, enter the user name and password.

Signon:Similar to the logon mode of page jump, you must set $ cfg ['servers'] [$ I] ['signonurl'], after you enter the phpmyadmin remote logon address, the URL set by signonURL is automatically displayed.

Cookie:That is, the login method when phpmyadmin is configured.

Now the installation and configuration of phpmyadmin3 have been completed, and you can experience the new features of phpmyadmin.