I want to make arch talk to fc3, where arch serves as mysql server and fc3 is the client. Obviously there is a major version mismatch. Is there some way to make the versions talk through some kind of compatibility program or plugin?
Have you tried it?
It might work, even with the version mismatching
To err is human... to really foul up requires the root password.
Nope, it doesn't... That's why I'm asking.
Database error was: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I think this is the answer:
Here's the command I used for mythtv:
UPDATE mysql.user SET Password = OLD_PASSWORD('mythtv') WHERE CONVERT(`Host` USING utf8) = '192.168.1.%' AND CONVERT(`User` USING utf8) = 'mythtv';
you can always install the old mysqlclient on your archlinux machine, install it it /usr/local/ and pacman should leave it alone; make sure you use the full path to get to the correct one. I did something like this to get mysqlcc to work on a SuSE install