heres my problem:

i cannot log in to phpmyadmin with my mysql logins

ive setup the control user, and that works im pretty sure because it shows the user in the database (using webmin)

i can login to view my databases in webmin, but webmins mysql functions are really not what i like to use

so phpmyadmin came in and i set it up how it said, with the control user, and im trying to use http as the authentication, now if i remove roots password from the database, and then try and access phpmyadmin with root and password left blank, i can get into phpmyadmin, but as soon as i password my root in mysql i cannot access phpmyadmin

the same thing happens with every other mysql user, they cannot login with passwords, but as soon as i remove the passwords, they can get in

i have no idea whats going on, i cant see a .htaccess file in the directory, so i gather there isnt one there

if anyone has any help on this, please let me know

thanks
-Ben

Mysql version: 4.1.12-standard
php version: 4.3.9
apache version: 2.0.52
linux: fedora core 3


UPDATED:
i found that it wont connect because the client version that PHP is displaying is 3.23.** and thats incorrect, because im using the one from 4.1.12

anyone know how to fix that??

ok found out how to get around it for now

mysql> SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');

this was the error i was getting but the http authorisation didnt display it till i changed it to cookie:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

that then lead me to scope out what was wrong

hope this helps anyone else with the same problem