This is the
admin cmd prompt readout of what happens when I do the various things as recommended in various places ...
- Code: Select all
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Zorro>cd c:\xampp\mysql
c:\xampp\mysql>C:\xampp\mysql\resetroot.bat
101023 15:05:07 [Warning] Can't create test file \usr\local\mysql\data\Zorro-box
.lower-test
101023 15:05:07 [Warning] Can't create test file \usr\local\mysql\data\Zorro-box
.lower-test
mysql\bin\mysqld.exe: Can't change dir to '\usr\local\\mysql\data\' (Errcode: 2)
101023 15:05:07 [ERROR] Aborting
101023 15:05:07 [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 . . .
c:\xampp\mysql>cd c:\xampp\mysql\bin
c:\xampp\mysql\bin>C:\xampp\mysql\bin\mysql.exe
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N
O)
c:\xampp\mysql\bin>C:\xampp\mysql\bin\mysqld.exe
101023 15:06:09 [Warning] Can't create test file \usr\local\mysql\data\Zorro-box
.lower-test
101023 15:06:09 [Warning] Can't create test file \usr\local\mysql\data\Zorro-box
.lower-test
C:\xampp\mysql\bin\mysqld.exe: Can't change dir to '\usr\local\\mysql\data\' (Er
rcode: 2)
101023 15:06:09 [ERROR] Aborting
101023 15:06:09 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
c:\xampp\mysql\bin>C:\xampp\mysql\bin\mysqldump.exe
Usage: mysqldump [OPTIONS] database [tables]
OR mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help
c:\xampp\mysql\bin>C:\xampp\mysql\bin\mysqldump.exe database
mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using pas
sword: NO) when trying to connect
c:\xampp\mysql\bin>
As you can see, nothing appears to be working ...
I can't get in because I have no password.
I can not change the password because I can't get in.
The resetpassword program run from
xampp\mysql does not work. (Even when attempted using the 'mysql-init.txt password change and flush' script operation).
All of my previous attemps at moving, renaming, rewriting etc ... the various .inf .conf .txt files from and too the various places alluded to here and, on the internet in general , have come to no fruitful avail either
I am at a loss as to what to do, really, perhaps a reinstall is the only option.