On 03/16/2010 12:56 PM, Raymond J. Henry wrote:
Then I try:
mysqladmin -h myserver.mydomain.com -u root password SQLROOTPASSWD.
use -p or --password
"mysqladmin ... password foo" sets the password, to give a previously set password, just do "mysqladmin -h myserver.mydomain.com -u root -p" to be prompted for it. Or to give it on the command line --password=SQLROOTPASSWD/-pSQLROOTPASSWD.
Peter