Road sign Oulu Finland

How to setup an SSH tunnel to access phpMyAdmin on Google Compute Engine

The other day I was working on Google Compute Engine, and I set up a new WordPress site on the Google Compute Engine. I run into an issue with phpMyAdmin as it gave me a warning when I tried to access it through the web browser, the message “For security reasons, this URL is only accessible using localhost (127.0.0.1) as the hostname”

The Google Compute Engine is using bitmani to deploy apps into the cloud, so when I selected the WordPress installation in Google Compute Engine, I used the bitmani wiki to find answers about how to use phpMyAdmin.

What I had to do was to set up an SSH tunnel

ssh -N -p 22 <username>@<ip address server> -L 8888/localhost/80

You could also use programs as putty or other similar applications to make this happen.

After you open the SSH tunnel you access the PHPMyAdmin in your browser like this – 127.0.0.1:8888/phpmyadmin

Some other useful article on How to ssh tunnels for secure network access


Posted

in

,

by

Comments

3 responses to “How to setup an SSH tunnel to access phpMyAdmin on Google Compute Engine”

  1. plancton Avatar
    plancton

    thank you very much Torbjorn : the very important information is : you access the phpyAdmin in your browser like this – 127.0.0.1:8888/phpmyadmin !!
    it is not clearly said in all other tutorials. You saved me a lot of time !!

    1. plancton Avatar
      plancton

      Unfortunately, I’ve not succeded yet… First login with root and blank password was forbidden (allownopassword= false in config.inc.php) . I change the and now I have : Access denied for user ‘root’@’localhost’ !!! Arrrgh….
      phpmyadmin was preinstalled along with the magento stack via Cloud launcher :
      https://cloud.google.com/launcher/solution/bitnami-launchpad/magento

      1. plancton Avatar
        plancton

        very very strange : the password is the bitnami password for the default user called user initially created by bitnami but it must be used with root !!!

Leave a Reply to plancton Cancel reply

Your email address will not be published. Required fields are marked *