Hi, It still failed. But if I tried to use GRANT to create a new user without password, then this new user can access MySql;
Why? How can I fix it? Please help! Thanks! wei --- Riccardi Moreno <[EMAIL PROTECTED]> wrote: > 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 > __________________________________________________ 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
