mysql error.

[Hatake Kakashi]

why there's a current password when i install this

mysql essential 5

and when i remove program at start menu>control panel>add or remove programs. and i reinstall mysql essential still i need to put current password and the apply security settings error...

what i need to do is to reinstall all new and password too.. thank you.

help.

Edited June 1, 2012 by Hatake Kakashi

[RCharles]

If you've got access to the root account already, because you know the password, you can change it easily:

steve@steve:~$ mysql --user=root --pass mysql

Enter password:

mysql> update user set Password=PASSWORD('new-password-here') WHERE User='root';

Query OK, 2 rows affected (0.04 sec)

Rows matched: 2 Changed: 2 Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.02 sec)

mysql> exit

[Hatake Kakashi]

i can't remember password..

or else i need to reformat my OS?

Edited June 2, 2012 by Hatake Kakashi

[Brian]

Follow these instructions to reset the root MySQL password:

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