The problem is that when I only define the "%" host, then no password is required to log in... (not a wanted feature!). I CAN log in, i just have to specify no password.
The password checking is only done for localhost.... --- [EMAIL PROTECTED] wrote: > 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] > > __________________________________ 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]