SOLVED: phpmyadmin multi server remote access

Discussion in 'Installation/Configuration' started by Marcoszx12r, Oct 7, 2016.

  1. Marcoszx12r

    Marcoszx12r New Member

    HI

    I installed 5 servers following the ISPconfig 3.1 Manual.

    web.domain.ltd
    mail.domain.ltd
    db.domain.ltd
    ns1.domain.ltd
    ns2.domain.ltd

    can i login the local mysql root with the phpmyadmin, but can't login the db.server.com database.
    maybe i need any alteration on the web.domain.ltd ISPconfig control panel.
    I'm used to single server, i need help to adjust the phpmyadmin on the multserver.
     
  2. Marcoszx12r

    Marcoszx12r New Member

    Solved.

    edit /etc/phpmyadmin/config.inc.php

    Code:
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    $cfg['Servers'][$i]['host'] = 'db.domain.ltd';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    /* Select mysqli if your server has it */
    $cfg['Servers'][$i]['extension'] = 'mysql';
    /* Optional: User for advanced features */
    // $cfg['Servers'][$i]['controluser'] = 'pma';
    // $cfg['Servers'][$i]['controlpass'] = 'pmapass';

    now you can select localhost or db.domain.ltd on phpmyadmin
     

Share This Page