Remotely access magento’s phpmyadmin (bitnami install)

1) First access the configuration file here: /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf

2) In the SSH command prompt window, allow this file to be modified (777) by entering the following command:

sudo chmod 777 /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf

3) Then, edit the file with a text editor and replace the following lines of code:

<IfVersion < 2.3 >
Order allow,deny
Allow from 127.0.0.1
Satisfy all
</IfVersion>
<IfVersion >= 2.3>
Require local
</IfVersion>

With this:

<IfVersion < 2.3 >
Order allow,deny
Allow from all
Satisfy all
</IfVersion>
<IfVersion >= 2.3>
Require all granted
</IfVersion>

4) Next, in the SSH command prompt window, restart apache by entering the following command:

sudo /opt/bitnami/ctlscript.sh restart apache

5) Revert back file permissions to original (644)

sudo chmod 644 /opt/bitnami/apps/phpmyadmin/conf/httpd-app.conf

6) Finally, refresh your internet browser and connect to PHP My Admin via the following url: http://SERVER IP/phpmyadmin/ or https://SERVER IP/phpmyadmin/

The ID should normally be “root” and the password is the same as the original password for Magento (check your Google Cloud Console).

Calling a static block on a page in Magento 2

If you want to call static block in page

Try below code :

{{block class="Magento\\Cms\\Block\\Block" block_id="block_identifier"}}

If you want to call in phtml file :

Try below code :

<?php echo $block->getLayout()->createBlock('Magento\Cms\Block\Block')->setBlockId('block_identifier')->toHtml();?>

Your xml file code should be :

<referenceContainer name="sidebar.additional">
   <block class="Magento\Cms\Block\Block" name="yourblockid">
       <arguments>
            <argument name="block_id" xsi:type="string">yourblockid</argument>
       </arguments>
   </block>
</referenceContainer>

At Last if you want to call phtml with your block in cms page :

Try below code :

{{block class="Magento\Modulename\Block\Blockname" template="Magento_Modulename::templatefilename.phtml"}} 

Refer this link for more details – https://chetansanghani.wordpress.com/2015/11/20/magento2-display-static-block-in-phtml-file-cms-page/