error in phpmyadmin in new nodes

Comments

1 comment

  • Avatar
    Ashraf Sharif

    Hi,

    It sounds like phpMyAdmin is running in a remote host without the MySQL socket file. Inside config.ini.php, you have to make sure you specify the correct IP address of the target database node:

    $cfg['Servers'][$i]['host'] = '10.0.0.118';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';

    If you have multiple servers that you want to access from a single phpMyAdmin, you can do the following:

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

    $i++;
    $cfg['Servers'][$i]['host'] = '10.0.0.130';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['AllowNoPassword'] = false;

    You will see a new dropdown called "Server Choice" in the login page. Make sure the MySQL user has access from the phpMyAdmin host. On Galera node, create the user beforehand using the following statement:

    GRANT ALL PRIVILEGES ON <database>.* TO '<user>'@'<phpmyadmin host>' IDENTIFIED BY '<password>'

    Regards,
    Ashraf

Please sign in to leave a comment.

Powered by Zendesk