Thank you for your reply, I will add 4th parameter.

Sorry for the mis-understanding, I'm still thinking in terms of exactly two servers (MySQL master and MySQL slave). By saying "from slave server to master server", I mean connecting from phpmyadmin (which is connected to *slave* MySQL server at the moment) to master MySQL server.

Tomas

Marc Delisle wrote:

Tomas Srnka a écrit :

...

Hello,

is there a function similar to PMA_DBI_connect, which can connect to a remote MySQL server?

I need to connect from slave server to master server and get current master binary log name and position for correct slave start.

Thank you,

Tomas

Hello Tomas, this function connects to the MySQL server defined in $GLOBALS['cfg']['Server']. It could be modified to add a 4th parameter $special_server which would have a mixed type: by default it would be false, meaning to use $GLOBALS['cfg']['Server'], but you could pass it an array defining the "other" server you want to connect to.

When you write "from slave server to master server" I don't understand. Connections are always done from the web server to some MySQL server.