PhpMyAdmin installation tutorial full guide and empty password login Implementation Method

Source: Internet
Author: User

PhpMyAdmin installation tutorial full guide and empty password login Implementation Method

Because I upgraded the php tutorial to 5.3.1, and the previous phpmyadmin version was unavailable, When I upgraded to phpMyAdmin 3.2.4, I was unable to log on to the root user with a blank password. How can this problem be solved? Follow these steps:

1. Open the directory where the program is located

2. Find the config. default. php file under the libraries directory

$ Cfg ['servers'] [$ I] ['allownopassword'] = false; change

$ Cfg ['servers'] [$ I] ['allownopassword'] = true

PhpMyAdmin Installation Guide
1, first download phpMyAdmin installation package, http://www.phpmyadmin.net
2. decompress the package to a separate directory (you can customize the directory name)
3. Find the/libraries/config. default. php file (the old version is the config. inc. php file under the root directory) and edit it with a WordPad (do not use Notepad, this is UTF8 encoding.
4. Search for $ cfg ['pmaabsoluteuri ']
Modify the phpMyAdmin URL that you will upload to the space
For example, $ cfg ['pmaabsoluteuri '] = 'HTTP: // www.phpfans.net/phpmyadmin /';
5. Search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'; (the default value is usually used, and there are exceptions. You do not need to modify the value)
6. find $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
Debug config in your own machine. If you use cookies in the network space, now we have added the web site before, and then modify it to a cookie. We recommend that you use cookies here.
7. find $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (user name, use root on your machine; this is generally your ftp user name on the Internet, which the VM provider will tell you. Do not change it)
8. find $ cfg ['servers'] [$ I] ['Password'] = ''; // MySQL password (only needed
You don't need to set it in your machine. leave it blank.
9. find $ cfg ['servers'] [$ I] ['only _ db'] = ''; // If set to a db-name, only (if you only have one data, set it. If you want to set up a server on your local computer, leave it blank)
10. find $ cfg ['defaultlang '] = 'zh'. (select the language. zh indicates the meaning of Simplified Chinese)
11, save after setting, now you can upload to the network space, browse http://www.bKjia. c0m/phpmyadmin/test.
Of course, if you set it differently, use that URL. Here is an example of knowledge.
12. Additional instructions:
In fact, if you are buying a virtual host, you do not need to do this. The reason for setting phpmyadmin is that everyone wants to set up a server. If "the configuration file now requires a top secret phrase password (blowfish_secret) appears) "Set the cookie of your website in the equal sign of $ cfg ['blowfish _ secret'] ='';, for example: $ cfg ['blowfish _ secret'] = 'www .phpfans.net '; this is because your "$ cfg ['servers'] [$ I] ['auth _ type'] = 'cookies.

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.