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 ...