At 21:12 -0700 6/1/04, Greg Willits wrote:
I'm trying to force 4.1.2 to use the old short passwords for now
during some experimental stages.
The discussion here (specifically the fourth set of bullets):
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
and, this paragraph:
"The Password column must be wide enough to hold long hashes
(41 bytes). If the column has not been updated and still has the
pre-4.1 width of 16 bytes, the server notices that long hashes
cannot fit into it and generates only short hashes when a client
performs password-changing operations using PASSWORD(), GRANT, or
SET PASSWORD. This is the behavior that occurs if you have upgraded
to 4.1 but have not yet run the mysql_fix_privilege_tables script to
widen the Password column."
led me to think that I could modify the user table and set the width
of the Password column to varchar(16) and based on the narrow column
4.1.2 would always default to creating the old passwords.
After narrowing the column, did you leave the server running?
Or did you restart it?
However, GRANT statements are creating passwords that start with *
so, even though they're chopped off at 16, they're obviously still
the new format.
---------------------
Sidebar: interesting--mysql 4.0 creates host, user, password
columns as binary but 4.1.2 does not?
---------------------
Can 4.1.2 be forced to used old passwords this way? Do I need to
modify the startup script to include --old-passwords?
-- greg willits
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]