Apache Friends Support Forum

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...

do you have any other usernames you could log in to to export the data. How much data are you talking about losing here?

I have tested with other users, but the same result no login...

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 config.inc.php).

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...)

can you post the code for the fixed resetroot.bat file?

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
http://www.apachefriends.org/jp/faq-xampp-windows.html#password2

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.
http://blog.livedoor.jp/real_systems/archives/51166848.html
However, same errors are occurred.

I need correct resetroot.bat...

You could try the methods documented here: http://dev.mysql.com/doc/refman/5.0/en/ ... sions.html