Password formats 3.23-4.x

[Nils Valentin]

Hi MySQL fans ;-),

I tried to get some experience with converting between the different password
formats as describd here:

http://www.mysql.com/doc/en/Password_hashing.html

So I took this sample

mysql> UPDATE user SET Password = OLD_PASSWORD('mypass')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

modified it a bit and found out that sometimes it would not let me do this
with an logical operator like = but instead wants LIKE or RLIKE.

I am using 4.1 alpha , so it is possible hat this is a bug of course. Does
anybody have similar experience ?
mysql> UPDATE user SET Password=OLD_PASSWORD('mypassword') WHERE Host like
'localhost' AND User like 'root';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql> UPDATE user SET Password=OLD_PASSWORD('mypassword') WHERE Host rlike
'localhost' AND User rlike 'root';
Query OK, 1 row affected (0.24 sec)
Rows matched: 1 Changed: 1 Warnings: 0

See that finally the RLIKE worked. So Ia m a bit confused now as I would have
expected the LIKE function to work, but perhaps this is a special case ??

Any reply appreciated.

--
---
Valentin Nils
Internet Technology

E-Mail: ni**@knowd.co.jp
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw