i do not have a root password when i first installed mysql on my winxp
i followed the instructions written on the article
http://dev.mysql.com/tech-resources/articles/securing_mysql_windows.html
but only until the step 5
i also did the following:
update user set password='hello' where user='root'
i entered also the skip-networking and enable-named-pipe on my.ini in winmysqladmin window
i accidentally closed the winmysqladmin window and thus shutting down mysql
i tried going into mysql again, but the following appears:
host 'localhost' is not allowed to connect to this MYSQL server
i checked under c:\windows\system32\drivers\etc\hosts
there already is a line 127.0.0.1 localhost
pls help!