PHPMYADMIN not found or wrong link in the ISPConfig 3

maybe I have found a little error in the ispconfig layout. If I click at the connection database link button at the database management page, I am redirected at the http://dbserver.mydomain.com/phpmyadmin.

As described in the manual the phpmyadmin has been installed in the webserver and not in the dbserver.

Hi Ive installed ISPconfig3 on Debian Squeeze on a dedicated server with 3 available IP's and everything works fine except for phpmyadmin.

When I create a database I can access phpmyadmin from the ISPconfig panel by clicking the connection to phpmyadmin from the sites/database interface, but I cannot login with the username and password I just set up.

I can login to mysql server from command line by doing

mysql -u root -p

so mysql server is running

remote access is also ticked

Ive set phpmyadmin interface on ISPconf to http://xx.xx.149.228/phpmyadmin/ which I can open but wont except username and password ( #1045 Cannot log in to the MySQL server
)

I'm experiencing the same issue as mturillo on the multi-server setup outlined in the manual. PhpMyAdmin ends up on the webserver and is configured to connect to the localhost while the ISPConfig interface is creating client's databases on the dedicated database server.

I manually added my db host to /etc/phpmyadmin/config.inc.php like mturillo but you still run into the problem of clients having to allow remote access to the entire internet or knowing the IP address of your main ISPConfig server.

My first instinct was to change the defaults in the interface form (ispconfig/interface/web/sites/form/database.tform.php) and prefill the checkbox and IP address. Obviously kind of a hack that wouldn't survive upgrades.

I see in that same database.tform.php script it pulls the database server names out of the configuration. Would it make sense to automatically grant remote access to nodes configured as webservers? Leaving the remote access checkbox and IPs to servers outside of ISPConfig control...