root password

[Naoise]

So the root password was set to something that is currently unknown, how can I go about resetting it?

I can see in the mysql database, ie the following path

C:/program files/mysql/data/mysql

in the file user.MYD that the user root appears to have password root but it does not seem to work. Any ideas? I don't have the disk to reinstall at the moment. Running version 4.0.21-nt, thanks

 

[TonyGroves]

You could copy the user table, edit the new table to blank out the root password, stop the server, overwrite the user table files with the edited table, restart the server, and set the root password.

 

[DonQuichote]

Read the Fine Manual. There is a section about just your situation. And the server can be started with a skip option so it does not need any password.