I have completed MySQL installation on my windows machine .I can navigate to C:\mysql\bin directory .When I use " >mysqladmin -uroot password abcdef " ,to set up admin user name and password this error is shown:
mysqladmin: connecting to server at'localhost' faild
error: access denied for user: 'root@localhost' (Using password: NO)'

But I can connect to the data base by usinig only username and not any password .And the result is that I can not USE the mysql data base ,however I can use the test database.

Note that I am the administrater of this machine and both the server and the client are installed on my machine.

Thanks in advance.

najib

You need to do...

mysqladmin -u root -p command

then enter the mysql password when prompted.

Note: you _can_ specifiy the password on the command line, but then anyone running 'top' or otherwise watching the processes on the box will see the password in the command arguments displayed.


-Vijay G