I'm trying set up the password for my root access and so I'm guessing that the username must be root isn't it suppose to be? For as far as I know, I haven't set up any special username (e.g. my name) or any password yet. I have just learned (in book) to configure MySQL installation. And here's where I reach:
1.) c:\mysql\bin\mysql (I tried using c:\mysql\bin\mysql mysql
but it said access denied)
2.) mysql> DELETE FROM user WHERE Host='localhost' AND User=''; (and this is where I stuck)!
And this is the method I used for checking the Database list show databases;
(found in www.mysqlfreaks.com
P.S. This is my first time using MySQL... very very first.... :( What do you think goes wrong?