phpMyAdmin Configuring login username and password Tutorial _php tutorial

Source: Internet
Author: User
Tags mysql login
This article to introduce to you in the phpMyAdmin configuration MySQL login management password Oh, below I take root user as an example to introduce the introduction of students, there is a need to understand the friends can refer to.

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

In general, if your MySQL and phpmyadmin on the same server, the hostname is directly using localhost

The code is as follows Copy Code

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

Then you configure the username and password for MySQL:

The code is as follows Copy Code

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

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

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

HTTP//website domain/phpmyadmin/Access

Some other methods

D. Authentication methods

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

There are four different modes to choose from, Cookie,http,http,config
The Config method is to enter the phpMyAdmin access URL directly, no need to enter the user name and password, is not safe, is not recommended to use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies
My personal advice: whether it is local or on the network, it is recommended to set cookies, security first.

E. Setting of the phrase password (blowfish_secret)

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

If the authentication method is set to a cookie, you will need to set the phrase password, put in the setting why the password, it is up to you to decide, but can not be left blank, or you may be prompted with error when logging in phpMyAdmin
F. Setting the default language and encoding
Find

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


In phpMyAdmin, there are a total of four ways to sign in

Config: Enter the phpMyAdmin telnet address directly, as long as the user name password is set in the configuration file.

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

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

Cookies: This is the way to log in when phpMyAdmin is configured.

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

http://www.bkjia.com/PHPjc/630717.html www.bkjia.com true http://www.bkjia.com/PHPjc/630717.html techarticle this article to introduce to you in the phpMyAdmin configuration MySQL login management password Oh, below I take root user as an example to introduce the introduction of students, there is a need to understand the friends can refer to. Phpmy ...

  • Related Article

    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.