mysql : changing root password

Question

I mistakenly keyed in

<delete from mysql.user where password =''>

Unfortunately the password for user is ''.

When I try to use mysqladmin i am getting message that I cannot set password for

<root @ localhost>

Any ideas???

Many thanks

Answer 1

If you are using a Unix-like OS:

1. You have to kill the mysql daemon.
2. Create a text file and write:

UPDATE mysql.user SET Password=PASSWORD('YOUR_PASSWORD') WHERE User='root';

FLUSH PRIVILEGES;

1. Open a console and type "mysqld_safe --init-file=YOUR_FILE &"
2. Restart the server
3. Now you should be able to work.