How to set the phpMyAdmin access password in bugfree use

Source: Internet
Author: User
Tags http authentication password protection

Introduction: when learning Bugfree, many students reflect the need to remote access to phpMyAdmin, but the configuration of the network access, found that phpmyadmin do not need to login to get in, feel insecure, so there is a bit of configuration, Help everyone to set password and normal username and account login phpMyAdmin.


The steps are as follows:

1, First of all, we recommend that you check whether you set a series of security accounts, enter the Linux system command terminal, input: sudo/opt/lampp/lampp security;


2, then will appear some of the column account settings, everyone set down the line, the overall settings are as follows:

xampp:quick Security check ...
xampp:your XAMPP pages is not secured by a password.
Xampp:do want to set a password? [Yes] Yes (1)
Xampp:password: ******
Xampp:password (again): ******
Xampp:password Protection Active. Please use ' lampp ' as user name!
Xampp:mysql is accessable via network.
Xampp:normaly that's not recommended. Does want me to turn it off? [Yes] Yes
xampp:turned off.
xampp:stopping MySQL ...
xampp:starting MySQL ...
xampp:the mysql/phpmyadmin User PMA has no password set!!!
Xampp:do want to set a password? [Yes] Yes
Xampp:password: ******
Xampp:password (again): ******
xampp:setting new MySQL PMA password.
xampp:setting phpMyAdmin ' s PMA password to the new one.
Xampp:mysql has no root passwort set!!!
Xampp:do want to set a password? [Yes] Yes
xampp:write The Passworde somewhere down-make sure you won ' t forget it!!!
Xampp:password: ******
Xampp:password (again): ******
xampp:setting new MySQL root password.
xampp:setting phpMyAdmin ' s root password to the new one.
xampp:the FTP password for user ' Nobody ' was still set to ' Lampp '.
Xampp:do want to change the password? [Yes] Yes
Xampp:password: ******
Xampp:password (again): ******
xampp:reload ProFTPD ...
Xampp:done.


3, if after the set up (preferably restart LAMPP service), or can not be accessed through the account and password phpMyAdmin, then need to modify a file.

Open the config.inc.php in the phpMyAdmin root directory and modify it as follows:

$cfgservers[$i [' auth_type ']= ' config '; modified to:

$cfgServers [$i] [' auth_type ']= ' cookie ';


4, save the file, re-visit phpMyAdmin can use the password of the account.

As shown in the following:

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/84/2C/wKiom1eHUw3DMV-rAABWogcNKjc336.png-wh_500x0-wm_3 -wmp_4-s_1756926412.png "title=" phpMyAdmin login page "alt=" Wkiom1ehuw3dmv-raabwogcnkjc336.png-wh_50 "/>

Description: There are three kinds of configuration parameters, Cookie,config and HTTP respectively;

1),cookies: Use the cookie login authentication, display a Web login page, enter the MySQL username and password, and then go to the admin interface. Generally, the use of the cookie method;

2),config: the MySQL user name and password directly into the config.inc.php, do not display the login interface, directly into the management interface;

3),http: Use HTTP authentication, display a Windows login box, enter MySQL username and password, and enter management. If you are using iis+php, HTTP authentication is not valid, and this feature can only be used in an Apache server environment.


Bugfree software testing tools for Linux practical courses

Http://edu.51cto.com/course/course_id-4855.html


This article from "Hao Yang _ Habitat" blog, please be sure to keep this source http://zdytesting.blog.51cto.com/5811414/1826440

How to set the phpMyAdmin access password in bugfree use

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.