What about using the username only instead of username@"%" ? According to manual (section 7.34) it should be identic in behaviour: [...] The simple form user is a synonym for user@"%". [...]
Does it do the same? Lian P.S. Andy, sorry for posting by mistake to you. ;-| > -----Original Message----- > From: Riaan Oberholzer [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 9:19 AM > To: [EMAIL PROTECTED] > Subject: Problem setting/activating password > > > Hi, > > I am created a user by using: > > GRANT ALL ON *.* TO username@"%" IDENTIFIED BY > "password" > > I did this from the mysql command line tool, logged in > as root. The command succeeds and the new user is > created in the mysql.user table, but the password does > not work. I can only use this new user if I use a > empty string password (no password). > > I also tried to do the SET PASSWORD afterwords, no > luck. I then tried the Windows GUI / Administration to > grant access and then set the password, but again, > only an empty string password is accepted. > > I am using mysql 4.0.13. > > How do I actually get the password validation to be > activated and instruct the server that the new user > must provide his password? > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]