MultiServer problem on PhpMyAdmin

Discussion in 'Installation/Configuration' started by MikySal78, Oct 4, 2019.

  1. MikySal78

    MikySal78 Member

    Error access..
    In Server Master (web) add in /etc/phpmyadmin/ vars:
    /* Configure according to dbconfig-common if enabled */
    /********** ADD HOST ********/
    $dbserver '';
    if (!empty($dbname)) {
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    /* Server parameters */
    if (empty($dbserver)) $dbserver '';
    $cfg['Servers'][$i]['host'] = $dbserver;
        if (!empty(
    $dbport) || $dbserver != 'localhost') {
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['port'] = $dbport;
    it's ok ...i logged in db bat i have error:
    • OpenSSL error: error:140E0197:SSL routines:SSL_shutdown:shutdown while in init
    • mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'' (using password: YES)
    • Connessione per controluser come definito nella configurazione fallita.
    how can i solve?
  2. Frost

    Frost Member

    if you are adding DB connection from your web server try to add this code at the end of /etc/phpmyadmin/

    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['host'] = ';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['extension'] = 'mysqli';

    For access denied error. You need to allow phpmyadmin login from Run this in your db server.
    GRANT ALL ON phpmyadmin.* to [email protected]'' IDENTIFIED BY 'password';

Share This Page