Hi, I found that if I set it as user1@localhost, other than @"%", it worked.
Anyone knows how to create users who can access MySql from anywhere under windows OS? Thanks! --- wei song <[EMAIL PROTECTED]> wrote: > 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