ludo wrote:
>
> # /usr/mysql/5.0/bin/mysqladmin -u root password root
> /usr/mysql/5.0/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Maybe I misunderstood the question, but seems you're trying to change
the mysql 'root' users password again after having set it earlier?
But, you're not authenticating when attempting to do it (now that
there's a password set) so it won't let you.

Try "mysqladmin -p -u root password root"

(I haven't actually tried it, I'm just reading the manpage.)

% MANPATH=/usr/mysql/5.0/man man mysqladmin

(As always, you shouldn't pass the password on the command prompt
since that's insecure.)
-- 
Jyri J. Virkki - jyri.virkki at sun.com - Sun Microsystems

Reply via email to