Bug #14996 user password entry in user table not possible with md5 encr
Submitted: 16 Nov 2005 20:19 Modified: 16 Nov 2005 22:57
Reporter: juerg hofer Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.15 OS:Windows (windows)
Assigned to: CPU Architecture:Any

[16 Nov 2005 20:19] juerg hofer
Description:
user password entry in user table not possible with md5 encryption because length 32 compared to char(16) of table field 

How to repeat:
should be very easy to repeat
[16 Nov 2005 22:57] Hartmut Holzgraefe
So you upgraded from an older installation without performing the necessary steps,
esp. running "mysql_fix_privilege_tables"

see http://dev.mysql.com/doc/refman/5.0/en/upgrade.html 

and esp. http://dev.mysql.com/doc/refman/5.0/en/upgrading-grant-tables.html

and http://dev.mysql.com/doc/refman/5.0/en/mysql-fix-privilege-tables.html