Password is not accepted from phpmyadmin.

Hi all I have debian system where I updated mysql from 4.0 to 4.1. The problem is password hash which has changed as well.
Is there any solution how to use long hash and phpmysqladmin or do I have to use short hash.

I tried to use "old-passwords" option under "[mysql]" in /etc/mysql/my.cnf. When I restart mysql service and type "mysql -u root -p" I recieved:
mysql: unknown option '--old-passwords'

Can someone help

 

Is there any way how to change in the ISPConfig code to create password for databases with OLD_PASSWORD option.
Reference:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

http://www.mysql.org/doc/refman/5.0/en/old-client.html

 

What's in /etc/mysql/my.cnf?

 

It would be a nice option to have this as an extra!

This week I needed to convert 7 MySQL DB's to work with the OLD_PASSWORD option :/

Code:

mysql -u root -p
Enter password: ....

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2380 to server version: 4.1.11-Debian_4sarge5-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

SET PASSWORD FOR
'web38_u1'@'localhost' = OLD_PASSWORD('this_sucks');
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

 

thank you till,

I have now added this, and I think it should do the trick.

Code:

[MYSQLD]
old-passwords

 

@Edge

I think you have to add this under [MYSQLD], but not as you suggested:

#Default to using old password format for compatibility with old and
#shorter password hash.
#Reference: http://dev.mysql.com/doc/mysql/en/password_hashing.html
old_passwords=1

 

Hans,

I was getting error's with my option (after restarting the MySQL some days later), so I removed it again..

I'll give your option a try later this week.

 

Hi Edge,

I've testes both options as i have upgraded mysql form 4.0.24 to 4.1.11.
It works ok on my Debian server.

If you have questions, we share our experiences. (As always)