Trouble connecting to mysql on another plesk server

[Roosta21]

I have two plesk servers and a domain setup in round robin

I would like server1 to connect to server2's databases and access the mysql data i have already setup. using the same database user login credentials

keep any data writes/reads in one place..

but if i set up a external in plesk control on server 1.. and input i.e. the plesk login creditals for server 2 (which is the admin account for mysql) it returns an error

: Test connection to the database server has failed because the supplied account does not possess administrative privileges:

Access denied for user admin'@'server2.com' (using password: YES)

 

[Roosta21]

plesk loggin the external database

Okay I managed to access to the database by setting up another user with privileges similary to admin..

So in the server > database server.. it allows me to connect to my external plesk database.. but it does it does not show the external databases

If i create an external database in server's 1 control panel (the database resides on server 2) it can see that database no problem.

But the database is not visbile on server2 control panel even though thats where is located.. If you access mysql through the command line you can see it fine..

Is there anyway of getting plesk(control panel) server 2 to log a all the databases on server 1

 

[Amin Taheri]

Each plesk server will check its own local psa database to keep track of those things, if you want it to work differently then unfortunately you will need to write a custom page for plesk to keep track of the databases and display the results to your customers.