Hi,
I'm currently having a similar issue. I can't run the resetroot.bat to reset my root password. The output I get when I do is:
100424 12:15:50 [Warning] Can't create test file \usr\local\mysql\data\Yoda.lowe
r-test
100424 12:15:50 [Warning] Can't create test file \usr\local\mysql\data\Yoda.lowe
r-test
mysql\bin\mysqld.exe: Can't change dir to '\usr\local\\mysql\data\' (Errcode: 2)
100424 12:15:50 [ERROR] Aborting
100424 12:15:50 [Note] mysql\bin\mysqld.exe: Shutdown complete
Passwoerter fuer Benutzer "root" und "pma" wurden nicht geloescht!
Passwords for user "root" and "pma" were not deleted!
Press any key to continue . . .
Again, I don't know why it's looking for this directory. I've installed to "C:\ApacheFriends\xampp\" as I'm on Vista 32 bit (and installing to Program Files is a bad thing so I've read). I used the latest April 2010 XAMPP windows .exe installer. I fixed up the directories as prompted during the configuration command prompt.
So having set up and being fairly new to this, somehow after following the suggestion to change my root user password I either set it to a hash value, or removed the root priveleges. (The page I did this on didn't explain very well what it was for, however it did allow my to change the password. It certainly wasn't the
http://localhost/security/ page). myphpadmin at this point would no longer let me log in because it required a password that I didn't know. (I know to change the password in the phpmyadmin/config.inc.php - but ofc don't know what it is now!)
I uninstalled xampp, the apache and mysql services and reinstalled in the same place. It still required a password I didn't know.
I manually deleted the entire "C:\apachefriends\xampp directory" and reinstalled. It still required a password I didn't know.
I found a number of articles explaining how to manually reset the root user password using a text document and running the mysql server to execute it. It failed, with the same text as quoted above.
I found the resetroot.bat and ran it. It failed, as the quote above showed.
I honestly can't believe how hard it is to: (A) remove the database and its settings and (B) reset the root password. I've failed on both counts. So now I'm posting here, to find out how to make this resetroot.bat file work correctly. I'm starting to despair. I've spent the last 2 days trying to figure it out. This thread is still dangling on the same issue, so I thought I'd bring it back.
Thanks in advance, Muffy.