error in phpmyadmin in new nodes
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
-
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.
Comments
1 comment