[SOLVED] interconnectivity with 2 servers

[Humpty]

G'day Guys,

 

I have 2 servers:

1) power - MSQL Ver: 5.0.18

2) demo - MSQL Ver: 5.0.24

 

I am trying to run PHP code on the POWER server to query stuff in mysql on the DEMO server.

 

We have full access to the servers and the mysql installations  (from an admin point of view) and can make any required alterations to apache, php or mysql.

 

There is two of us and neither of us have ever tried this before.

 

As a matter of interest we can access POWER mysql from running scripts on DEMO quite happly, now we need to do the opposite.

 

What are the steps i need to do to make all this happen?

 

First Error:

Warning: mysql_connect(): Host 'POWER' is not allowed to connect to this MySQL server in /usr/home/power/connectFunction.php

 

Then  used the phpMyAdmin to create a new user with host set to the appropriate 'POWER' server.

 

Current Error:

mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client

 

usinig the command line we can connect from POWER to DEMO but it just won't happen in php script.

[Humpty]

Even though both versions are greater than 4.1 using the following command did the trick:

 

mysql> SET PASSWORD FOR

    -> some_user@some_host = OLD_PASSWORD('newpwd');

 

We used that command on the DEMO server.