MySQL password prob

[PanzerKnight]

I set my mysql pass as follows

C:\mysql\bin>mysqladmin -u root password ****

then i tried this command

C:\mysql\bin>mysql -p ping
Enter password: ****
ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: YES)

have no idea whats up. Tried reinstalling mysql and resetting the pass to.

If one of u guys can shed some light on it would be most appreciated, thanks!! Only just started using mysql, after a rather brief stint trying to learn orcale (waaay over me)

Thank you!

[DaBeeeenster]

I set my mysql pass as follows

C:\mysql\bin>mysqladmin -u root password ****

then i tried this command

C:\mysql\bin>mysql -p ping
Enter password: ****
ERROR 1045: Access denied for user: 'ODBC@localhost' (Using password: YES)

have no idea whats up. Tried reinstalling mysql and resetting the pass to.

If one of u guys can shed some light on it would be most appreciated, thanks!! Only just started using mysql, after a rather brief stint trying to learn orcale (waaay over me)

Thank you!

You need to set the user you are connecting as - on windows it defaults to ODBC.

So start mysql with

mysql -uroot -p ping

[PanzerKnight]

ah ha!!!
thanks matey