imposibble to reset root password

Problems with the Windows version of XAMPP, questions, comments, and anything related.

imposibble to reset root password

Postby ironmansp » 26. March 2008 18:49

resetroot.bat does not reset the passwords
"count column incorrect" says

and I can not access to mysql database to change the permissions..

please help...
Posts: 24
Joined: 26. February 2007 14:59

Postby DouglasAWh » 26. March 2008 22:33

do you have any other usernames you could log in to to export the data. How much data are you talking about losing here?
Carolina Open Source Initiative Co-Founder
Seeking Employment May 2008
Posts: 3
Joined: 24. March 2008 21:42
Location: Chapel Hill, NC

I can not login wit any user

Postby ironmansp » 27. March 2008 08:55

I have tested with other users, but the same result no login...
Posts: 24
Joined: 26. February 2007 14:59

Postby bzgzd » 08. April 2008 17:24

Yes resetroot.bat is wrong. :!:

I downloaded and installed XAMPP today (1.6.6a) and after i changed root password i was no more able to use phpmyadmin (even when i updated

So i wanted to reset root password with that batch file but it is not working.

I had to reinstall XAMPP and then i checked it and corrected resetroot.bat (it had wrong number of columns). I had to increase number of 'Y' entries for root to 28 (instead of 21) and also added one zero at the end. (for pma user also - adding 7 'N' and one zero)

Now at least i can reset root and pma passwords (but still can't set it to different then empty for some reason...)
Posts: 1
Joined: 08. April 2008 17:02

batch file

Postby mindshare » 17. April 2008 19:39

can you post the code for the fixed resetroot.bat file?
Posts: 1
Joined: 17. April 2008 19:38

my resetroot.bat is incorrect too

Postby ethocabpya » 30. May 2008 20:38

I want to reset my MySQL root password.
I tried to do resetroot.bat with I saw following web site.

apache friends - xampp windows版faq

But some errors are occurred.

ERROR: 1136 Column count doesn't match value count at row 1
080531 4:23:36 [ERROR] Aborting

080531 4:23:36 [Note] bin\mysqld.exe: Shutdown complete

Passwoerter fuer Benutzer "root" und "pma" wurden geloescht.
Passwords for user "root" and "pma" were deleted.

I tried to modify with following site.
However, same errors are occurred.

I need correct resetroot.bat...
Posts: 1
Joined: 30. May 2008 20:09

Postby Dave_L » 30. May 2008 22:06

You could try the methods documented here: ... sions.html
User avatar
Posts: 212
Joined: 23. October 2004 00:43

Return to XAMPP for Windows

Who is online

Users browsing this forum: roxy39 and 66 guests