That IS confusing - I didn't assign any password?!?!?! There is no password! That's why I asked how to get rid of mysql and start installation from scratch :) thanks patrick -afan
* afan@afan.net
[09-29-06 15:46]: Your response previous was quite ambiguous (as I read it).
but what I wanted to say is I tried # mysqladmin version got: ERROR 1045: Access denied for user: 'root@localhost' (Using Password: NO)
so root already has a password? ( the prompt "#" indicates root).
tried: # mysqladmin -u root version and got the sam error message
which was the same as "mysqladmin version" since you *were* root.
tried assign password: # mysqladmin -u root password 'MyPass' and got the same error message
So root already had a password and you cannot logon w/o the password.
# mysqladmin -u root -p password 'MyPass'
and tty will ask you for the password, but, it will not by 'MyPass' (I don't think).
Thanks for trimming your quote and not "top posting". -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org HOG # US1244711 Photo Album: http://wahoo.no-ip.org/gallery2 --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
--------------------------------------------------------------------- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org