Still could not get it to work so I uninstealled and reinstalled. Will use the anonymous login etc util I figure out this security system. Is there a document that explains the password system in laymans terms?
Art -----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 4:08 AM To: [EMAIL PROTECTED] Subject: Re: Setting root password in mysql for windows Art, Thursday, August 15, 2002, 7:12:40 AM, you wrote: AF> Having a hard time coming to grips with the password setup for mysql in AF> windows. I follow the instructions below from the documentation. AF> C:\> C:\mysql\bin\mysql mysql AF> mysql> DELETE FROM user WHERE Host='localhost' AND User=''; AF> mysql> QUIT AF> C:\> C:\mysql\bin\mysqladmin reload AF> C:\> C:\mysql\bin\mysqladmin -u root password your_password AF> All goes well until the last line and In type "mysqladmin -u root password AF> my_password". AF> I get AF> mysqladmin: connect to server at 'localhost' failed AF> error: 'Access denied for user: 'root@localhost' (Using password: NO)' AF> What is the cause of this and how can I fix it? Does user 'root' have a password? If so, you should use mysqladmin -u root -p password newpassword and enter old password in the password prompt or mysqladmin -u root -poldpassword password newpassword -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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