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 | [email protected] | 20130605082131 |
6cddefa506a7c33b9a7372af70c69604 | NULL | NULL | NULL |
20071015111247 | 1132 |
+---------+-----------+----------------+-------------------------------------+----------------------------------------------+-------------------+---------------------+----------------+----------------------------------+--------------------------+------------------+--------------------------+-------------------+----------------+
So maybe the problem is caused by PHP?
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
