I have installed xampp, I did the security settings, but after a time I have forgot the root password. I have google it, how to reset, the problem seems he can't create lower-lower-test file, because he try to accesss a Unix path on my windows PC :), lol. xamp config.
the resetroot.bat gives me this output:
101108 15:37:23 [Warning] Can't create test file \usr\local\mysql\data\MYCOMPUTERNAME.lower-test 101108 15:37:23 [Warning] Can't create test file \usr\local\mysql\data\MYCOMPUTERNAME.lower-test mysql\bin\mysqld.exe: Can't change dir to '\usr\local\\mysql\data\' (Errcode: 2) 101108 15:37:23 [ERROR] Aborting 101108 15:37:23 [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 . . .
The .bat file has the following important parts:
PUSHD %~dp0 CD .. mysql\bin\mysqld.exe --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone resetroot.err 2>&1 IF ERRORLEVEL 1 GOTO FEHLER GOTO KEINFEHLER :FEHLER TYPE resetroot.err ECHO. ECHO Passwoerter fuer Benutzer "root" und "pma" wurden nicht geloescht! ECHO Passwords for user "root" and "pma" were not deleted! GOTO WEITER :KEINFEHLER ECHO. ECHO Passwoerter fuer Benutzer "root" und "pma" wurden geloescht. ECHO Passwords for user "root" and "pma" were deleted. ECHO. ECHO Bitte den MySQL Server neu starten. ECHO Please restart the MySQL server. GOTO WEITER :WEITER DEL resetroot.err >nul 2>&1 DEL resetroot.sql >nul 2>&1 ECHO. POPD PAUSE
at mysql bin directory is a my.ini file
# Point the following paths to different dedicated disks tmpdir = "C:/xampp/tmp/"
Don't know from where is coming that Unix path and where to change, what parameter.
Is there any other way to reset the mysql root password until I have this errors?