[Fratello]

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.

[Vince]

This assumes that you know the current root password. Because if you don't you can't login to phpMyAdmin and this tutorial is worthless. Furthermore, you shouldn't use root for actual projects. Create a new user for each project and assign that user only the permissions that it requires. Usually only the DML statements (select, insert, update, delete).