phpMyAdmin configuration login username and password tutorial_PHP tutorial

This article will introduce to you how to configure the mysql login management password in phpmyadmin. Below, I will use the root user as an example to introduce it to students. Friends who need to know more can refer to it.

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

Generally speaking, if your mysql and phpmyadmin are placed on the same server, just use localhost as the host name

The code is as follows

代码如下	复制代码
$cfg['Servers'][$i]['host'] = 'localhost';

Copy code

代码如下	复制代码
$cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = *****';

$cfg['Servers'][$i]['host'] = 'localhost';

Then you need to configure the username and password of mysql:

The code is as follows

Copy code

代码如下	复制代码
$cfg['Servers'][$i]['auth_type'] = 'cookie';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = *****';

There is no need for these basic configurations for the time being. Then upload phpMyAdmin to the server root directory using

代码如下	复制代码
$cfg['blowfish_secret'] = '';

http://website domain name/phpMyAdmin/ Visit

Some other methods

D. Authentication method

代码如下	复制代码
$cfg['DefaultLang'] = 'zh';

There are four modes to choose from, cookie, http, HTTP, config The config method is to enter the access URL of phpmyadmin to enter directly without entering the user name and password. It is unsafe and not recommended. When this item is set to cookie, http or HTTP, logging in to phpmyadmin requires a data username and password for verification, as follows:

PHP installation mode is Apache, you can use http and cookies;

PHP installation mode is CGI, you can use cookies

My personal suggestion: Whether it is local or online, it is recommended to set cookies, safety first.

E. Phrase password (blowfish_secret) settings

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

If the authentication method is set to cookie, you need to set a phrase password. It is up to you to decide what password to set, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin F. Set default language and encoding Find In phpmyadmin, there are a total of four login methods Config: Just enter the phpmyadmin remote login address directly. Just set the username and password in the configuration file. http: A dialog box will pop up, enter your username and password and enter Signon: A login method similar to page jump. At the same time, $cfg['Servers'][$i]['SignonURL'] needs to be set. When you enter the remote login address of phpmyadmin, it will automatically jump to signonURL. URL set. Cookie: This is the login method when phpmyadmin is configured. At this point, the entire installation and configuration of phpmyadmin3 is completed, and you can experience the new features of the new version of phpmyadmin.

http://www.bkjia.com/PHPjc/630717.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630717.htmlTechArticleThis article will introduce to you how to configure the mysql login management password in phpmyadmin. Below I will use the root user as an example. Dear classmates, please introduce it. Friends who need to know more can refer to it. phpMy...