• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1011
  • Last Modified:

Old Password Format MYSQL


I am running Windows 2003 and mysql 4.1.22

I am trying to disable the old password format -

I have used the follow commands, but neither make any difference.

SET global old_passwords=0;
SET SESSION old_passwords=0;
SET global old_passwords=false;
SET SESSION old_passwords=false;

The following command returns -

mysql> SELECT @@session.old_passwords, @@global.old_passwords;
| @@session.old_passwords | @@global.old_passwords |
|                       1 |                      1 |
1 row in set (0.00 sec)

Can anyone help?
  • 2
1 Solution
Dave BaldwinFixer of ProblemsCommented:
According to this page http://dev.mysql.com/doc/refman/5.5/en/password-hashing.html ,
The Password column must be wide enough to hold long hashes (41 bytes)
If your MySQL installation was upgraded from a previous version, that might not be true.
RobOwner (Aidellio)Commented:
You are logged in with an account that can change these permissions?
RobOwner (Aidellio)Commented:
Did you try:

SET @@global.old_passwords=0;
SET @@session.old_passwords=0;
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now