PhpMyAdmin user name and password configuration tutorial

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.