Phpmyadmin multi-server setup

Discussion in 'ISPConfig 3 Priority Support' started by Stelios, Dec 1, 2020.

  1. Stelios

    Stelios Member HowtoForge Supporter

    Hi all,
    I've added a new server to my multi-server setup which holds web & db.
    I've got my PHPMyAdmin installed only to the master (controlpanel) server.
    My conf.d/config.manyhosts.inc.php file holds their entries:
    Code:
    $hosts = array (
        "localhost", // controlpanel --> 10.0.0.4
        "10.0.0.6", // db1
        "10.0.0.7", // db2
        "10.0.0.14" // db3
        //"baz.example.com",
        //"quux.example.com",
    );
    I can login fine on the db1 and db2 server but on this one I got:
    Connection for controluser as defined in your configuration failed.

    db1 and db2 don't have installed phpmyadmin but searching the databases on them I can see that there is a phpmyadmin db while on the new server (db3) it doesn't.

    I've run the following queries to the db3 server:
    Code:
    db1 shell>
    mysql> create user 'root'@'10.0.0.4' identified by 'MyPassword';
    mysql> grant all on *.* to 'root'@'10.0.0.4' identified by 'MyPassword' with grant option max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 max_user_connections 0;
    mysql> create user 'root'@'panel.example.com' identified by 'MyPassword';
    mysql> grant all on *.* to 'root'@'panel.example.com' identified by 'MyPassword' with grant option max_queries_per_hour 0 max_connections_per_hour 0 max_updates_per_hour 0 max_user_connections 0;
    Would please anyone post the required steps to connect via phpmyadmin from my master server?
    I tried creating the db manually from another server but didn't work.

    Connecting to the master server when I install the ISPconfig was without a problem, it is just the phpmyadmin.

    Thanks in advance
     
    Last edited: Dec 1, 2020
  2. Stelios

    Stelios Member HowtoForge Supporter

    False alarm....it was the bloody firewall.
     
    Last edited: Dec 1, 2020
    Th0m likes this.
  3. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    It always is ;)
     

Share This Page