Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Re^2: input compare

by anniyan (Monk)
on Jul 11, 2005 at 08:21 UTC ( #473869=note: print w/replies, xml ) Need Help??

in reply to Re: input compare
in thread input compare

frodo72, just now i tested in mysql prompt by executing the select statement,it is not working in my system. But in my friend's system when i executed the same select command, it is working properly. He is also having the same version. I am spending last 4 hours to get rid off this problem, but i can't.


Replies are listed 'Best First'.
Re^3: input compare
by polettix (Vicar) on Jul 11, 2005 at 08:32 UTC
    How I would proceed:
    SELECT CONCAT('[', passwd, ']') FROM test WHERE user='anniyan'
    This will show the password currently registered for user 'anniyan'. Note that I enclose the password field contents inside square brackets, just to see if there is any annoying char somewhere. If there is no such user, you've found the bug. Then:
    SELECT PASSWORD('insert-your-password-here') FROM test
    (I don't remember if the FROM section is needed here) This will show you what is the encrypted form of the password you're trying to use. There should be no need for brackets here, but if you're paranoid add them. If the password is not equal to the one above, you've found the bug - probably you made a typo when inserting the password. Just reset it in the database (using an UPDATE command) and you're done.

    Enough guessing for the moment :)

    perl -ple'$_=reverse' <<<ti.xittelop@oivalf

    Don't fool yourself.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://473869]
[karlgoethebier]: marioroy ;Men need a challenge
Lady_Aleena remembers winning dodgeball and wonders why parents who played it will not let their kids play it.
[marioroy]: Disciplus My wife and I went on vacation. At work, I was stuck polling SNMP from 20 million devices. It would hang at 80,000. On the mist boat, hear a voice to enable grace in the design that 10x and more performance awaits.
[Lady_Aleena]: Women need challenges too karlgoethebier. 8)
[marioroy]: s/hear/heard/
[karlgoethebier]: Discipulus: No. See https://en. wiki/Tribe_( Native_American)
[karlgoethebier]: They took Unix from some aliens
[marioroy]: Perl is so powerful that it can poll 40 metrics from 20 million devices in 40 minutes using 4 nodes only.
[karlgoethebier]: http://www. aliens.htm
[Lady_Aleena]: marioroy, I can't decide whether or not to move my RolePlaying:: Random:: modules to just Random::. I'm not as sophisticated as most here.

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (12)
As of 2017-05-29 08:51 GMT
Find Nodes?
    Voting Booth?