Mysql 4.1 upgrade and password issues

[Awalsh]

A while back i upgraded my interworx vps from mysql 3.23 to mysql 4.1 using the guide on the interworx site. Everything worked fine (php scripts can connect and do everything needed etc) but recently i decided to use phpmyadmin (as i needed to, it is built into interworx but i hardly ever use it). And i cannot get in with any account created by interworx, yet using the root login details i can get in fine.

I have found that the problem lies with the encryption used on the mysql 4.1 compared to mysql 3.23. I am using "old_passwords" under the [mysqld] option in /etc/my.cnf but i still cannot login with accounts created when i was running mysql 3.23.

So my question is there anything im missing? The fact that php can connect using the account details that are being rejected by both phpmyadmin and the mysql prompt confuses me. Is there a way to force usage of the old password encryption for the entire mysql server?

Thanks for any help

Andrew

[gerilya]

phpmyadmin is in fact a bunch of php scripts, so if "php scripts can connect and do everything needed", I would suggest installing your own copy of phpMyAdmin and see whether it works.

If your own copy of phpmyadmin works fine, then the problem is related to some specific way the control panel configures its copy of phpmyadmin and that should be addressed by the control panel provider.

Just my 2 cents.

[Vin DSL]

You might try cookie auth. That's what I use on my shared account. Never cared for basic auth...

[Awalsh]

when i say php scripts can connect i mean i have an account setup with the username awalsh. I use the login details in a php script and it works fine, but if i try these same details in phpmyadmin it says that the details are incorrect.

Is there a way of just setting the mysql server to use the old password scheme's from mysql 3.23? Because id like to avoid installing my own version of phpmyadmin as it would mean updating all the themes that other accounts use to link them up.

[gerilya]

Awalsh,

I suggested installing your own copy of phpMyAdmin because it's the simplest way to troubleshoot your problem, not because I think you should use one in production environment

[Vin DSL]

And, if you decide to run your own install, please note...

http://www.lenon.com/phpMyAdmin

I consider this is to be the 'latest stable version', not 2.8.0.3!

[Awalsh]

Im stilling running like 2.5.x on my interworx install. I wonder when Iworx will get the updates into their repo's or even just provide a simple RPM. As ive found out in the past its better to wait for one of their RPM's instead of using others for some strange reason i did a mysql 4.1.x install using mysql rpm's and it broke the control panel. Yet the iworx rpm worked fine.