PDA

View Full Version : [Tutorial] How to put a new password in 'XAMPP' ( Reseting current one)



SergiuOfficial
17-06-17, 08:36
How to put a new password in 'XAMPP' ( Reseting current one)
Hello,

I will teach you how to reset XAMPP password today

What is XAMPP?

XAMPP is a free and open source cross-platform web server solution stack package developed by Apache Friends,[2] consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages.[3][4] XAMPP stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely easy for developers to create a local web server for testing and deployment


How to change the password?
Step(s):

1. First step: Start Apache & MySQL from Control Panel (xampp's)
2. Second step: Go in myphpAdmin ( http://localhost/phpmyadmin/ or clicking 'admin' on control panel )
3 .Third step: Nice! Now go to 'SQL' tab! ( )
4. Fourth step: Well done! Now go to zone where you can type ( SQL queries )
5. Fifth step: Copy following text to it and click 'Go'
HTML Code:
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root'; FLUSH PRIVILEGES;
Warning !: instead of Password=PASSWORD('password') you can put your own password, like ('mypasword')
Do not change User='root' (You can change if you have changed it in config file )

6. Sixth step: OK! Now go to installation folder of XAMPP, then to 'phpmyadmin' then find file called 'config.inc' [ Type of the file is .php ]

7. Seventh step: Open it via notepad/++\ .. other text editors. And look for:
Code:
$cfg['Servers'][$i]['password'] = ' ';
8. Eighth step: Edit ['password'] to your own password ( Same password we have put before )
9. Finishing step: Now save and close the file and turn off Apache and MySQL then start them up and all fine!


// Comment: You shoudn't face any problems! If you do please post them here, thanks.

Download this type of post.