GCP

How to Access phpMyAdmin in the Bitnami Stack Google Cloud.

Bitnami made its PHPMyAdmin very secure in its stack, you can’t access it just by typing its path to the address bar like https://example.com/phpmyadmin. To access the bitnami PHPMyAdmin page you should create an SSH tunnel that will allow you to connect to the localhost 127.0.0.1, and you can access the application.

Access phpMyAdmin Bitnami
Access phpMyAdmin Bitnami

How you can access PHPMyAdmin in the Bitnami stack over SSH Google Cloud?

For this you’ve to go through following steps:

  • Download puTTY application
  • Generate SSH key using this application
  • Update or configure the publish key to host i.e. google cloud in our case.
  • Configure the puTTY application for localhost connection that would allow us to access PHPMyAdmin remotely.
    • Session settings
    • SSH auth key settings
    • SSH Tunnel Settings
    • and Connection data setting
    • Save and Open session settings

Download puTTY Application

First, you to download the puTTY application that will create an SSH Tunnel environment for the localhost. It will be used to establish the connection between Google Cloud and the localhost machine.

putty-download
Download puTTY application

SSH Key Config

After installation, open puTTY gen and generate a SSH key and setup it on Google Cloud console Virtual Machine.

Generate SSH Key

putty-ssh-key
puTTY SSH key generate

Generate the SSH using puTTY key generator. Please follow the steps in the same order as discribed below.

  1. Place key comment as bitnami
  2. Now copy the public key
  3. Save the public key in a safe location for future use.
  4. Save the private key with the public key.

Note: Public key is for server-side service and private is for the user side. These keys can be used for FileZilla, and don’t place on public computers for security reasons.

Save SSH Public key to Google Cloud

Now open Google Cloud Platform Dashboard and visit the section Compute Engine> Metadata

Compute Engine Meta Data
Compute Engine Meta Data

Now paste the public key (copied from the puTTY key generetor) in the metadata section of Google Cloud.

meta-data-save-compute-engine
paste the SSH key to metadata
  1. Paste the SSH key by adding a blank item.
  2. Save the settings.

Configure the puTTY application to access PHPMyAdmin Bitnami localhost.

Putty Session Configuration

Now you’ve to configure the puTTY application for the bitnami PHPMyAdmin access.

Copy IP Address from Virtual Machine
Copy IP Address from Virtual Machine
  • Copy the IP address of the Virtual Machine VM.
puTTY Session Configuration
puTTY Session Configuration
  1. Paste the IP address in the saved sessions
  2. Click on save button

puTTY Auth Configuration

puTTY Auth Configuration using private Key
puTTY Auth Configuration using private Key

Now visit the auth section of the puTTY and provide path of the private key for SSH key generator.

puTTY Tunnel Configuration

puTTY Tunnel Configuration
puTTY Tunnel Configuration

SSH tunnel Settings, Provide port number and destination as 8888, and localhost:80. You can also provide localhost:443 for HTTPS connections

  1. Provide the Source Port 8888, and destination localhost:80
  2. Click on add button

puTTY Data Configuration

puTTY Data Configuration
puTTY Data Configuration

Connection data settings, provide auto-login name bitnami as displayed above.

puTTY Session Configuration Final

puTTY Session Configuration Final, to login phpmyadmin Bitnami
puTTY Session Configuration Final

Final settings of Session:

  1. Select the IP Address
  2. Click on the Save button
  3. Now click on the load button provide.
  4. Paste the IP address in Host Name (copy it from the saved session as displayed).
puTTY Security Alert
puTTY Security Alert

Putty Security alert: want to save the cache in registry. Please click on No for security reasons.

Access phpMyAdmin of Bitnami Stack localhost

phpmyadmin-page-bitnami-stack
phpmyadmin-page-bitnami-stack

puTTY will start a connection now. And now you can access phpMyAdmin by visiting http://127.0.0.1/phpmyadmin for localhost:80, and https://127.0.0.1/phpmyadmin for localhost:443. If you are going to the HTTPS version then you’ve to click on Proceed to 127.0.0.1 (unsafe).

If you can’t access the phpmyadmin page, read this article.

Username for login is “root” and password is the initial wordpress password that can be find in Marketplace> Your Solution.

Login Details of phpMyAdmin.

The default username of PHPMyAdmin is root. And password can be located in the Google Cloud Marketplace > Your solution. You can access it using this link

phpmyadmin Bitnami Password
phpmyadmin Password
  1. Visit Google Cloud Dashboard, Click on Your Solution.
  2. Choose your application
  3. Check your password.

This password can be used with username root, in phpmyadmin.

Ashok Kumar

Ashok Kumar working in the Search Engine Optimization field since 2015. And worked on many successful projects since then. He shares the real-life experience of best SEO practices with his followers on seoneurons.com. You also can learn Advance level SEO for WordPress, Blogger, or any other blogging platform. Stay tuned.

Related Articles

Leave a Reply

Back to top button