PHPMyAdmin for remote DB server: tested workaround

Community Support Database
1

Hi,

This is my first post, so feel free to raise any issue with it !

I wanted to use Hestia PHPMyAdmin with a remote DB server. I read these previous posts (since I’m a new user, I’m not allowed to add links for both of them):

  • Phpmyadmin remote server
  • PHPMyAdmin 404 with remote DB server.

Then, I used this $i++; workaround to append my remote DB parameters to /etc/phpmyadmin/conf.d/01-localhost.php. It luckily did the trick (don’t know for how long…) ! Within PHPMyAdmin, I have now a dropdown menu that allows me to switch between my local and my remote DB.

HTH

Bilbo the Hobbyist

2

cool.
and you also did the ssh tunnel as mentioned in the stackoverflow link? If so, that would have to be redone each time the hestia server is rebooted. But maybe you didnt and your remote DB server is setup for remote access already.

1 Like
3

My remote DB server was already reachable, so I avoided the ssh tunnel :slight_smile: Thanks for the tip, anyway !