mysqladmin denies access

[Merkron]

I am running mysql(v 11.18, dist. 3.23.52) on Mandrake 9.0
I have created some databases at the mysql> prompt and can
successfully get there(mysql> prompt) as root user.

However mysqladmin is another story...

I have searched through this forum and checked the FAQ:s
but I cant find an answer.

If i try to log in with mysqladmin I get the wellknown?
'access denied for user root@localhost'(using password:YES)

I have tried:

mysqladmin -u root -p thepassword
(This prompts as described above)

mysqladmin -u root -p mysql (Then it promtps for a password)
(This prompts unkown command 'mysql' plus the above)

Is the password for getting in as root to mysql> prompt the
same as for getting in as root at mysqladmin> prompt ?

How do I get in as root with mysqladmin?

Please do not answer this question with what to do to
get in at mysql> prompt, this question is about mysqladmin.

Thanks in advance, best regards

Merkron

 

[Merkron]

Whoopsss!

Well...after some more testing and looking through
the net I found my answer

I will mention it here just in case somebody else
who come looking through the threads have overlooked
the same things I did..

mysqladmin yields no prompt, it is a command.

it should be entered as:

shell>mysqladmin -u user -pxxxx command
i.e.
shell>mysqladmin -u root -pblah create staff
(The above will create a database named staff)

Notice that there is no space between the -p
and the password.

Thats that.

Merkron