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.
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.
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
Generate the SSH using puTTY key generator. Please follow the steps in the same order as discribed below.
- Place key comment as bitnami
- Now copy the public key
- Save the public key in a safe location for future use.
- 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
Now paste the public key (copied from the puTTY key generetor) in the metadata section of Google Cloud.
- Paste the SSH key by adding a blank item.
- Save the settings.
Configure the puTTY application for localhost.
Putty Session Configuration
Now you’ve to configure the puTTY application for the bitnami PHPMyAdmin access. Copy the external IP address from your virtual machine.
- Copy the IP address of the Virtual Machine VM.
- Paste the IP address in the saved sessions
- Click on save button
puTTY Auth Configuration
Now visit the auth section of the puTTY and provide path of the private key for SSH key generator.
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
- Provide the Source Port 8888, and destination localhost:80
- Click on add button
puTTY Data Configuration
Connection data settings, provide auto-login name bitnami as displayed above.
puTTY Session Configuration Final
Final settings of Session:
- Select the IP Address
- Click on the Save button
- Now click on the load button provide.
- Paste the IP address in Host Name (copy it from the saved session as displayed).
Putty Security alert: want to save the cache in registry. Please click on No for security reasons.
Access phpMyAdmin of Bitnami Stack localhost
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).
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
- Visit Google Cloud Dashboard, Click on Your Solution.
- Choose your application
- Check your password.
This password can be used with username root, in phpmyadmin.