Chris Fonnesbeck wrote:
On 7/18/05, Michael Stassen <[EMAIL PROTECTED]> wrote:
Hmmm... In that case, I have more questions. Log in as root and run
SHOW VARIABLES LIKE '%pass%';
DESC user password;
and post the results.
Also, was this a brand new installation, or an upgrade? If an upgrade, from
what version?
This is a brand new installation, following a clean install of my OS.
Sorry, my question was imprecise. I meant to ask if you were using an earlier
version before this install. I expect the answer is yes, and you are using
the new 4.1 server with the old data.
Here are the commands you requested:
mysql> SHOW VARIABLES LIKE '%pass%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | OFF |
+---------------+-------+
1 row in set (0.03 sec)
mysql> DESC user password;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Password | varchar(16) | | | | |
+----------+-------------+------+-----+---------+-------+
1 row in set (0.00 sec)
Well, there's the problem. The Password column needs to be a varchar(41) to
hold the new 41 character password hash used by 4.1. Your Password column is
only a varchar(16), which is the old size. I'm guessing you copied in your
old data, but haven't run the mysql_fix_privilege_tables script. That should
update your Password column to fix this (among other things).
Still, the behavior you describe is not what the manual says will happen
<http://dev.mysql.com/doc/mysql/en/password-hashing.html>. It says, "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." You may have stumbled onto a bug, in which case
you should report it <http://bugs.mysql.com/>.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
