[debian-mysql] Bug#711254: Bug reported to MySQL

[Karsten Malcher]

Please refer to the bug at mySQL:
http://bugs.mysql.com/bug.php?id=69430

I have done an additional test now.
Up to now i used phpmyadmin to talk to mysql.


Now i tried to use the shell command instead.

mysql -u username -ppassword dbname -e "UPDATE user SET user_password = CONCAT(':A:', MD5('public')) WHERE user_name = 
'public'"

This seems to work.

mysql -u username -ppassword dbname -e"select * from user WHERE user_name = 'public'"
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+
| user_id | user_name | user_real_name | user_password                       | 
user_newpassword                             | user_newpass_time | user_email          | user_touched   | 
user_token                       | user_email_authenticated | user_email_token | user_email_token_expires | 
user_registration | user_editcount |
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+
|       2 | public    | Public         | :A:4c9184f37cff01bcdc32dc486ec36961 | 
:B:b50fb7bb:e5fcb263a54546d423589c83cc5b1263 | 20130605082126    | wiki at dct.mine.nu | 20130605082131 | 
6cddefa506a7c33b9a7372af70c69604 | NULL                     | NULL             | NULL                     | 
20071015111247    |           1132 |
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+

So maybe the problem is caused by PHP?