Access denied for user 'mysqladmin'@'localhost'

[stmfc]

i am trying to use mysql db for the first time.
i have installed mysql-noinstall-5.0.45-win32.zip to my pc.
although i didnt have set any password,
when i try to login for mysqladmin user via command prompt,
i am asked for the password then i get

ERROR 1045 (28000): Access denied for user 'mysqladmin'@'localhost' (using passw
ord: YES)

what can i do to reset the password, or to retrieve the password?

[mwasif]

Did you create the user 'mysqladmin'? Use root instead.

[stmfc]

thanks for the reply
i thought that mysqladmin is the name of the root user.
now i see that there is separate root user.
what i dont understand is:
is mysqladmin is a special user, or is it the same as other users?
do i have to create mysqladmin user?

[mwasif]

root is the super user of MySQL which can do everything (only in mysql;)). You need to create mysqladmin user using GRANT after being logged-in with root. Or you can use any GUI tool to maintain the DB e.g. HeidiSQL.

[pbmods]

Heya, stmfc.

There's no special significance to the mysqladmin User. You could just as easily use johhnybgood as the Username. As long as it has the proper permissions, you can log in with whatever account that you want.

The only exception is root, which is traditionally the superuser.

[bartonc]

i am trying to use mysql db for the first time.
i have installed mysql-noinstall-5.0.45-win32.zip to my pc.
although i didnt have set any password,
when i try to login for mysqladmin user via command prompt,
i am asked for the password then i get

ERROR 1045 (28000): Access denied for user 'mysqladmin'@'localhost' (using passw
ord: YES)

what can i do to reset the password, or to retrieve the password?

I'll bet that you skipped the Instance Configuration Wizard....
Start->Programs->MySQL->MySQL Server 5.0->MySQL Server Instance Configuration Wizard.

Then when you run MySQLAdmin click the Stored connection "..." button to set up your default login.