Arch Linux

kleptophobiac

Member

From: Sunnyvale, CA

Registered: 2004-04-25

Posts: 489

Possible to make different versions of mysql talk?

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?

oscar

Member

From: Kiruna, Sweden

Registered: 2004-08-13

Posts: 457

Re: Possible to make different versions of mysql talk?

Have you tried it?
It might work, even with the version mismatching

---

To err is human... to really foul up requires the root password.

kleptophobiac

Member

From: Sunnyvale, CA

Registered: 2004-04-25

Posts: 489

Re: Possible to make different versions of mysql talk?

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:
http://dev.mysql.com/doc/mysql/en/Old_client.html

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';

budgenator

Member

Registered: 2005-04-26

Posts: 8

Re: Possible to make different versions of mysql talk?

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