how to reset root password in phpmyadmin using xampp server

Question

HI Any one can help me that how i can reset my phpmyadmin root password. when i am going to open localhost/phpmyadmin i got this error..

" Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole by setting a password for user 'root'. "

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

Error : Token mismatch

I also try this method: After started XAMPP server, i go to the browser and type the URL localhost/security/ (incase you've modified XAMPP server port, you need to include that port number also in previous URL). The security page will be shown where you can change the root password for MySQL. This will update the phpMyAdmin config also.

i have follow this method but i cannot solve my problem plz help me out this problem

possible duplicate of Resetting MySQL Root Password with XAMPP on Localhost — Isaac Bennetch
– Isaac Bennetch, Commented Jul 29, 2015 at 14:52

Community · Accepted Answer · 2017-05-23 12:34:41Z

2

Go 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 of Resetting MySQL Root Password with XAMPP on Localhost

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered Jul 27, 2015 at 9:56

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Naveed Ashfaq Over a year ago

after doing this . when i am going to open localhost/phpmyadmin i got "Access Denied " this message

Naveed Ashfaq Over a year ago

i load this command in run i have this directory c > xamp > mysql > bin now what i to do in this directory??

Collectives™ on Stack Overflow

how to reset root password in phpmyadmin using xampp server

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related