Initially you will have had no password, so setting root's password to 'test1' would be done with:
mysqladmin -u root password test1 To change this password to test2 use: mysqladmin -u root -ptest1 password test2 Regards M -----Original Message----- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 12:59 To: [EMAIL PROTECTED] Subject: Password reset. I just installed mysql under my new linux system. I did a test command of ./mysqladmin -u root password new-password thus setting the root users password to "new-password" this appeared to work. I now want to change the root users password now that I have the syntax correct. I do a ./mysqladmin -u root -p password test1 this should set the password to test1 correct ? I get this error ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' can anyone explain why this is happening so that I can better understand how this command is working. Thanks, Matt. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php