How to Access phpMyAdmin in the Bitnami Stack Google Cloud.

Bitnami made its PHPMyAdmin very secure in its stack, and you can’t access it by typing its path to the address bar like https://example.com/phpmyadmin. Instead, 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

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

For this, you’ve to go through the 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 a 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. Then, it will be used to establish the connection between Google Cloud and the localhost machine.

Download puTTY application

SSH Key Config

After installation, open puTTY, generate an SSH key and set it up on Google Cloud console Virtual Machine.

Generate SSH Key

puTTY SSH key generate

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

1. Enter 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

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

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 the IP address of the Virtual Machine VM.

puTTY Session Configuration

1. Paste the IP address in thesaved sessions
2. Click on the Save button.

puTTY Auth Configuration

puTTY Auth Configuration using private Key

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

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

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

puTTY Session Configuration Final

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: want to save the cache in the registry. Please click on No for security reasons.

Access phpMyAdmin of Bitnami Stack localhost

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, you’ve to click on Proceed to 127.0.0.1 (unsafe).

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

The username for login is “root”, and the password is the initial WordPress password found 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 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.