myphpadmin and mysql access.. quick question

[Dek]

Installing joomla, and I'm guessing my host updated their mysql because I cannot install joomla or mambo even though it was working up until a few days ago..


I can login to create a db and see my username/pass is working fine since I can create new db's and such within phpmyadmin but apparently with the newer versions of mysql apparently there's an issue with now that mysql uses a 41 byte encryption instead of the older 16 byte encryption.

Now they have a way to fix that but I think I need to have the host run the script, because when i'm in the sql window i get bad feedback instead of what it should be doing. I'm guessing I'd need to be root instead..

I'm supposed to run this and it will allow the older passwords

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');


I need to login as root, right? And since I don't have that, I need to get my host to run it, to use the old pass, since I can't create a new user either.

[4days]

aye, like you say - you'll need to be able to update the mysql table itself, which means you need root permissions.

if you don't have any luck with your host, is there no way you can get the data out and stick it into a new db? quite mashed so i might be missing something in your post. are you trying to recover data, move data or set up a place to put data?

[Dek]

yeah, the issue is I can setup a new db, but mambo and joomla apparently are looking to use the old mysql 16 byte encryption and not the newer 41 byte encryption. I've change my password, and I can delete, create, databases just need to be able to switch it back to the old_password with 6 byte encryption, since I can't get mambo/joomla to see my database at all currently, just errors out failing to connect although I know they can communicate, apparently it's just my mysql was updated on the host in the last couple days.

I'll msg my host..