Re: Problem with query and password

2005-01-31 Thread Gleb Paharenko 
Hello.



Looks like passwords in your table are stored in old short format.

Use old_password() instead of password(). See:

  http://dev.mysql.com/doc/mysql/en/password-hashing.html



Lancer Emotion 16 [EMAIL PROTECTED] wrote:

 Hello everbody,i have a problem with mysql and i wish you could help me.

 I have this table named users :

 

 +++--+--+---+-+-

 +

 | ID | user   | pass | thegroup | firstname | surname | 
 enabled

 |

 +++--+--+---+-+-

 +

 |  1 | Admin  | *4ACFE3202A5FF5CF467 |  1 | Mr| Admin   |   1

 |

 |  2 | admin2 | *4ACFE3202A5FF5CF467 |  1 | Mr| Admin   |   1

 |

 +++--+--+---+-+-

 

 The password in both cases are : admin .

 When i do any of this querys :

 

 select * from users where pass=password(admin);

 select * from users where pass='admin';

 select * from users where pass=password('admin'); 

 

 i get an empty set, i dont know why.

 When i do : 

 

 select password('admin')

 

 i get :   *4ACFE3202A5FF5CF467898FC58AAB1D615029441

 

 Please help me.

 Thanks

 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with query and password

2005-01-29 Thread Lancer Emotion 16 
Hello everbody,i have a problem with mysql and i wish you could help me.
I have this table named users :

+++--+--+---+-+-
+
| ID | user   | pass | thegroup | firstname | surname | enabled
|
+++--+--+---+-+-
+
|  1 | Admin  | *4ACFE3202A5FF5CF467 |  1 | Mr| Admin   |   1
|
|  2 | admin2 | *4ACFE3202A5FF5CF467 |  1 | Mr| Admin   |   1
|
+++--+--+---+-+-

The password in both cases are : admin .
When i do any of this querys :

select * from users where pass=password(admin);
select * from users where pass='admin';
select * from users where pass=password('admin'); 

i get an empty set, i dont know why.
When i do : 

select password('admin')

i get :   *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Please help me.
Thanks

-- 
lancer emotion 16

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problem with query and password

2005-01-29 Thread Hassan Schroeder 
Lancer Emotion 16 wrote:
I have this table named users :

+
| ID | user   | pass | thegroup | firstname | surname | enabled
+++--+--+---+-+-
|  1 | Admin  | *4ACFE3202A5FF5CF467 |  1 | Mr| Admin   |   1

The password in both cases are : admin .
When i do any of this querys :
select * from users where pass=password(admin);
that one should work, except...
When i do : 

select password('admin')
i get :   *4ACFE3202A5FF5CF467898FC58AAB1D615029441
You wouldn't maybe guess that your pass field above is too small? :-)
FWIW,
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
  dream.  code.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]