Shulou(Shulou.com)06/01 Report--

Editor to share with you how to set phpmyadmin login password, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Config.inc.php

Unconfigured phpMyAdmin is insecure, vulnerable, or does not work at all. PhpMyAdmin has three authorization modes:

1.cookie: display a web login page, enter the user name and password of mysql, and then enter the administrative interface

2.http: display a windows login box, enter the user name and password of mysql, and enter the management

3.config: enter the mysql user name and password directly into the config.inc.php without displaying the login interface and go directly to the management interface.

The configuration file for phpMyAdmin is called config.inc.php, and the modification methods for each version of config.inc.php are as follows:

Previous version 2.6: change config.inc.sample.php to config.inc.php

Version 2.7: change config.default.php to config.inc.php

Version 2.8: use the configuration script'/ script/setup.php' to generate the configuration file, copy the generated file, and manually save it as config.inc.php

Configuration scripts provided in version 2.8 and above:

First, use cookie authorization mode to change 'auth_type' to' cookie', and then modify 'blowfish_secret' uses an arbitrary string as the encrypted string of cookie. If there is no encryption key, the system will display "the configuration file now requires a top secret phrase password (blowfish_secret)". The configuration file is as follows:

$cfg ['Servers'] [$I] [' auth_type'] = 'cookie'; $cfg [' blowfish_secret'] = '44e2f5aece2855.93921574'

After the modification, the web login page of http authorization mode

Second, use config authorization mode

Config requires these parameters:

$cfg ['Servers'] [$I] [' auth_type'] = 'config'; / / Authorization Mode $cfg [' Servers'] [$I] ['user'] =' root'; / / mysql login user $cfg ['Servers'] [$I] [' password'] = '12345 password; / / mysql login user password

Third, use http authorization mode

$cfg ['Servers'] [$I] [' auth_type'] = 'http'

Login window of http authorization mode

Note: if the mysql server uses version 4.1 or above, and the client connection uses the following version of mysql4.1, use the OLD_PASSWORD function when setting the password for the user.

For example:

Mysql > SET PASSWORD = OLD_PASSWORD ('12345') mysql > / G

Appendix: (the following is written by myself)

In addition to the above three phpmyadmin native methods, you can also use the configuration of apache to restrict login, place an. Htaccess file in the phpmyadmin directory, and specify the password record text to use.

Then use htpasswd to generate the password and save it in the password record file (the contents of the file are encrypted, using the method htpasswd / etc/php_passwd username).

What is in the httpd.conf:

Phpmyadmin's directory "> AllowOverride AuthConfig

Contents of the .htaccess file

Authtype basic authuserfile / etc/php_passwd authname information require valid-user

We can see that the / etc/php_passwd file looks something like this:

Username:2Y2CD6nfJuwL6

The change solution of canceling the maximum File limit in phpmyadmin

Appears when importing a large database with phpmyadmin:

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

First of all, check the following three places in the php.ini configuration file, upload_max_filesize, memory_limit and post_max_size, and it is recommended that the modified value is slightly larger than the imported sql database file; after modifying the above three values in php.ini, restart the php environment, or restart the computer, and when importing again, although phpmyadmin still shows the maximum import limit: 20548KB, importing a large database file has been successful.

The above is all the contents of the article "how to set your login password in phpmyadmin". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.