phpMyAdmin Configure login username and password tutorial

Source: Internet
Author: User
Tags phpmyadmin

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.

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.