* afan@afan.net [09-29-06 15:31]:

I already tried this and I have 'Accesss denied...' error.

-afan

...

* afan@afan.net [09-29-06 14:32]:

...

I instaled mysql using yast. then, following a book, initilized tables by # /usr/bin/mysql_install_db

Grant tables are installed corretly becaus I got the message on screen I supposed to get.

I started mysql # /etc/init.d/mysql start

Ok.

But, when I tried to verify that the server is running # mysqladmin version I got 'error: Access denied for user: 'root@localhost' (using Password: NO)'

15:07 wahoo:~ > mysqladmin -p version Enter password: mysqladmin Ver 8.41 Distrib 5.0.24, for unknown-linux on x86_64 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.24 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 5 days 1 hour 47 min 23 sec

Threads: 1 Questions: 136184 Slow queries: 0 Opens: 62 Flush tables: 1 Open tables: 57 Queries per second avg: 0.311

I would think, with no password assigned for root: Usage: mysqladmin [OPTIONS] command command.... ~ > mysqladmin -u root version

or for current user, if current user *has* access: ~ > mysqladmin version ## with *no* password ~ > mysqladmin -p version ## password requested via tty

-- 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

??? "this" please note the "full" quoting and remarking prior to questions/comments. -- 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

* 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

* afan@afan.net [09-29-06 16:05]:

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

You're welcome. to get a record of *all* mysql files, do: locate mysql > some.file.name to get a record of *installed mysql files do: rpm -ql mysql > some.file.name.1 to remove mysql: rpm -e mysql to determine remaining mysql (configuration) files: kdiff3 some.file.name some.file.name.1 note: all remaining filenames do *not* need to be removed. Some are not config files, ie: /var/admin/perl-modules/perl-DBD-mysql (may not be on your system). ps: you "top-posted" again, and full-quoted (as I did also). Makes reading a pain, don't you agree? Plus it's discourteous :^) thanks for your expected consideration! -- 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