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