Before login with new account you must reload server with this command: mysqladmin -u root -ppass reload and then you could login with new account
-----Messaggio originale----- Da: wei song [mailto:[EMAIL PROTECTED]] Inviato: venerdi 16 novembre 2001 17.41 A: [EMAIL PROTECTED] Oggetto: Access denied for the new created user! Hi, I am a very beginner of mysql and studying the manul. I tried "set password for user1=PASSWORD('paasw'); " after logging in as root user. Then I quit, try to login as 'user1': C:\>mysql -u user1 -p and then entered the password "paasw". There always an error: Access denied for user:'user1@localhost'." Please help!!! Thanks! wei __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.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
