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