MultiServer problem on PhpMyAdmin

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

  1. MikySal78

    MikySal78 Member

    Using domain.com/phpmyadmin
    Error access..
    In Server Master (web) add in /etc/phpmyadmin/config.inc.php vars:
    PHP:
    /* Configure according to dbconfig-common if enabled */
    /********** ADD HOST ********/
    $dbserver 'db.ninux-basilicata.net';
    /**********************************/
    if (!empty($dbname)) {
        
    /* Authentication type */
        
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
        
    /* Server parameters */
        
    if (empty($dbserver)) $dbserver 'db.ninux-basilicata.net';
        
    $cfg['Servers'][$i]['host'] = $dbserver;
        if (!empty(
    $dbport) || $dbserver != 'localhost') {
            
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
            
    $cfg['Servers'][$i]['port'] = $dbport;
        }
    ...
    cut
    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'@'web.ninux-basilicata.net' (using password: YES)
    • Connessione per controluser come definito nella configurazione fallita.
    how can i solve?
    Thanks.
     
  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/config.inc.php

    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['host'] = 'db.ninux-basilicata.net;
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $i++;


    For access denied error. You need to allow phpmyadmin login from web.ninux-basilicata.net. Run this in your db server.
    GRANT ALL ON phpmyadmin.* to phpmyadmin@'web.ninux-basilicata.net' IDENTIFIED BY 'password';
     

Share This Page