Forgot my MySql 5.1 Root Password

I did that after I posted this and it didnt quite work, but set some things off and then it disabled InnoDB and Federated...

I tried to delete everything and install it again, tested if the password was still there, it was.
Stop MySql in the services and then followed the steps... and below is what I got... Out of the frying pan into the fire.

There are certain files and folder you can delete, to start from scratch, but I am working on Vista - pretty new to me... also in Portuguese, pretty new to me as well.



Microsoft Windows [versão 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. Todos os direitos reservados.

C:\Users\Marky>mysqladmin -u root status
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

C:\Users\Marky>mysqladmin -u root -p status
Enter password: ***
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

C:\Users\Marky>"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-f
ile="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" --init-file="C:\Users\Marky
\Documents\mysql-init.txt"
090816 23:08:58 [Note] Plugin 'InnoDB' is disabled.
090816 23:08:58 [Note] Plugin 'FEDERATED' is disabled.

C:\Users\Marky>UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='
root';
'UPDATE' não é reconhecido como um comando interno
ou externo, um programa operável ou um arquivo em lotes.

C:\Users\Marky>FLUSH PRIVILEGES;
'FLUSH' não é reconhecido como um comando interno
ou externo, um programa operável ou um arquivo em lotes.

C:\Users\Marky>

The message about InnoDB and FEDERATED disabled is normal, it is because you start the server in this special mode.

This is wrong:

C:\Users\Marky>UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

You must start the mysql client first:

C:\Users\Marky>"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql"

Then you get a mysql prompt:

mysql>

...then you can enter the UPDATE statement and FLUSH PRIVILEGES. Then shut down the server and start it the normal way.

I copied and pasted that line, but it says access denied... so I went to the directory and opened up mysql.exe and ...

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.37-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
ERROR 1142 (42000): UPDATE command denied to user ''@'localhost' for table 'user
'
mysql> FLUSH PRIVILEGES;

Did you follow the instructions on this page:

http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html

If so, the UPDATE statement is allready executed, you should just stop the mysql server, start it the normal way, and log in with the new password.

Thanks for all the replys btw,

Tried that, but still no access, using the MyNewPass

I want to throw the comp out of the window... is there an alternative?

Microsoft Windows [versão 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. Todos os direitos reservados.

C:\Users\Marky>mysqladmin -u root -p status
Enter password: *********
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

C:\Users\Marky>

This is very extreme ways:

1. BACKUP YOUR DATABASE before do this below !!!

2. Uninstall all your MySQL Installation.
3. Delete all MySQL related file,
4. Have you delete MySQL Folder in Program files?
5. Have you delete your MySQL data folder in
    C:\ProgramData\MySQL\MySQL Server 5.1
6. After finish delete all this MySQL related file, than re-install your MySQL as usual

Good Luck.