OK, one time it allowed me to set a password. However no form of this command seems to work for me so far. Is it the Using password: No telling me to not use a password?
So you noticed that now the error isn't "lost connection" any more, which means your first problem (with "-h dragonfly") is fixed.
And, you say that it let you set a password, once, and now nothing works? If so, that makes perfect sense, because once you have set the password, you can't do any mysqladmin commands without the password!
"Using password: NO" means that it didn't get any password from you.
You've got to keep separate: the "mysql -p xyz" that you use to authenticate in order to connect to the server; and the "mysqladmin password xyz" which means, set the password to xyz.
[EMAIL PROTECTED] ~ $ /usr/bin/mysqladmin -u root password xyz /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
After one successful "mysqladmin -u root password xyz", every following mysqladmin and mysql must supply the password. Try:
mysqladmin -u root -p xyz password newpass
OR
mysql -u root -p xyz
Also note that you can specify "-p " WITHOUT putting the password on the command line to have the program prompt you for the password instead.
-- Arran -- gentoo-user@gentoo.org mailing list
