RE: can't set a password

2002-05-07 Thread Brandon Metcalf
[EMAIL PROTECTED] writes: ^^ Oh forgot to ask in the last post, how are you setting the password in the ^^ first place? Are you using a grant statement or inserting values into the ^^ table. I reckon the former is better (and safer) but if you're doing the ^^ later the you need to "flush privli

RE: can't set a password

2002-05-06 Thread Noel Clarkson
Oh forgot to ask in the last post, how are you setting the password in the first place? Are you using a grant statement or inserting values into the table. I reckon the former is better (and safer) but if you're doing the later the you need to "flush privliges" after any changes so that mysql

RE: can't set a password

2002-05-06 Thread Noel Clarkson
See that line that says accept any user (%) from any host (%) with password null. There's your answer. It's a default entry that should be removed (I think there's stuff in the securing mysql section of the manual about this). cheers noel On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf

can't set a password

2002-05-06 Thread Brandon Metcalf
Okay, I'm obviously missing something here. Even though the submit_write user has a password set according to the SELECT output below, I can't use that password or any password to login as this user. Only a null password is accepted. The first attempt I enter the correct password; no go. The se