error in phpmyadmin in new nodes

Follow

edss

• February 06, 2018 05:45

hi,  i have setup 3 vultr vps to test the galera system the problem is that i need to install phpmyadmin but it have a error 

 

 

how can manage the database using phpmyadmin?  or is there an alternative that you recommend

0

• 

  Ashraf Sharif

  • February 06, 2018 06:09

  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

  0

  Comment actions Permalink

Please sign in to leave a comment.