I have looked everywhere, including MySQL's documentation. I get no error when I try to reset the MySQL password and I still can't reset the password.
I also logged in using mysqld.exe -u root --skip-grant-tables. I was able to get into mysql but even when I run
UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'root';
It says "Ok." But when I actually try to log in
mysql -u root -p
I still get an access denied error.
I tried uninstalling, I erased the whole MySQL folder even in C:\Program Files installation.
I try to install and it STILL has the password and I cannot find where the database is hiding so that I can delete it and build a fresh database with a new password since I don't have any important information.
I have installed it using all the default settings, tried googling for a quite a bit and I've run out of ideas.
Question
Tekkerson
Running latest MySQL on an old XP machine.
I have looked everywhere, including MySQL's documentation. I get no error when I try to reset the MySQL password and I still can't reset the password.
I also logged in using mysqld.exe -u root --skip-grant-tables. I was able to get into mysql but even when I run
UPDATE user SET Password = PASSWORD('NEW_PASSWORD') WHERE User = 'root';It says "Ok." But when I actually try to log in
I still get an access denied error.
I tried uninstalling, I erased the whole MySQL folder even in C:\Program Files installation.
I try to install and it STILL has the password and I cannot find where the database is hiding so that I can delete it and build a fresh database with a new password since I don't have any important information.
I have installed it using all the default settings, tried googling for a quite a bit and I've run out of ideas.
Any help with this Neowin? Pretty please?
Link to comment
Share on other sites
15 answers to this question
Recommended Posts