Re: Problem setting/activating password
mysqladmin -uroot -ppassword reload Curtis On Tue, 24 Jun 2003, Riaan Oberholzer wrote: > 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 > > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem setting/activating password
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]
RE: Problem setting/activating password
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]
Re: Problem setting/activating password
To also add priviliges on the local machine GRANT ALL ON *.* TO username@"localhost" IDENTIFIED BY "password" Riaan Oberholzer wrote: 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]
RE: Problem setting/activating password
I don't know if this apply when using GRANT but have you tried afterwards: > flush privileges; HTH, Lian > -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]
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]
