Saturday, November 3, 2018

How to access prestashop PHP my admin in bitnami google cloud hosting on windows

In order to access the PHP admin in the bitnami google cloud hosting it takes quite a complicated step but luckily it is no impossible and getting easier after doing it a few times. Note that this is a very important step to keep in mind because the PHP admin allows database backup and restore less hassle.



Follow this tutorial step how to access the PHP admin in bitnami Google cloud server:

Step 1: Putty Application.

In order to SSH to the bitnami server we need a puTTY app installed on windows - so I am using Windows 10 32-bit. You can download the installer from puTTY website if you don't have it yet.

Step 2: Login to Google Cloud Server

a. Login to Google cloud console > Compute Engine > VM Instances
b. Copy the VM External IP:xxxxxx of the hosted site and bitnami-base-password: xxxxxx and copy them to a notepad for later use.

how to backup prestashop database hosted in Google clouds bitnami server - cara backup prestashop database dari bitnami

Step 3: Login to Bitnami

a. Login to Bitnami Virtual machine click on Unlock Vault and click Virtual Machine where the PrestaShop is hosted - download the PPK key and keep it on safe folder in your computer for later use in puTTY configuration

how to restore database in phpmyadmin control panel prestashop hosted on Google bitnami

Step 4: Setting up Putty Configuration

a. Open Putty Application
b. Click on Session Under Host Name (or IP address) field enter the external ip address that you get from step 2 in Google Cloud server then enter the same ip address in the Save Sessions field and click Save.

setup SSH connection using putty to bitnami google cloud prestashop server

c. Click Connection > Data -- Auto-login username field enter bitnami

putty bitnami login username and password

d. Click SSH > Auth -- Then browse your pc and find the bitnami PPK key obtain from Step 3

bitnami ppk key for ssh using putty

e. Still under SSH click Tunnels and enter 8888 in the Source port and then enter localhost:80 in the Destination field and click Add

putty tunnel setting ssh for bitnami google cloud prestashop

f. The setting is done - now click Open a command prompt will pop up as below. Do not close the command prompt and leave it open that way and move on to the next step.



Step 5: Login to the PHP admin

a. Open any browser and enter http://127.0.0.1:8888/phpmyadmin
b. enter username: root and password: xxxx (obtained from Google cloud server in step 2)

You should be able to access PHPmyadmin control panel and backup the SQL database - and download it to your desktop. Restoring database also can be done through the admin control panel.

how to access phpmyadmin via putty to the bitnami google cloud

No comments:

Post a Comment