Clever Geek Handbook

How to reset root password in phpmyadmin using xampp server

HI Anyone can help me that I can reset my phpmyadmin root password. when i go to open localhost / phpmyadmin i got this error.

"The config file contains settings (root with no password) that match the default MySQL account. Your MySQL server runs with this standard, is open to intrusion, and you really should fix this security hole by setting a password for the root user."

and when i click on user to change my password i am facing this error

Error: token mismatch

I also try this method: After starting the XAMPP server, I go to the browser and type the url localhost / security / (if you changed the port of the XAMPP server, you need to include this port number in the previous url as well). The security page will be shown where you can change the root password for MySQL. This will also update phpMyAdmin config.

I am following this method, but I cannot solve my problem. Plz help me to solve this problem.

+3


source to share


2 answers


Switch to \xampp\phpMyAdmin\config.inc.php

then

$cfg['Servers'][$i]['password'] = 'WhateverPassword';//near line 21


or run this command

mysqladmin.exe -u root password 'WhateverPassword'

And Possible Duplicate Reset MySQL Root Password with XAMPP on Localhost

0


source


You access the command line (shell) through the XAMPP control panel (one of the buttons on the right). The control panel is accessed through the icon bar (in Windows).



-2


source






More articles:


All Articles