Trying to figure out bitnami access PhpMyAdmin? Our Support Team is here to save the day.
Accessing PhpMyAdmin via a secure SSH tunnel remotely is child’s play with this solution from the Support Engineers at Bobcares.
Dealing with bitnami access PhpMyAdmin
PhpMyAdmin is reachable only via 127.0.0.1 as the hostname. If you are looking for a way to access it from a remote system, you have come to the right place. Our Support Engineers offer you a solution where you create an SSH tunnel that will route the request to the webserver from 127.0.0.1. In order for this solution to work, you need to ensure that you can connect to the server via SSH in order to have remote access.
Access PhpMyAdmin on Windows
First, ensure you can access PhpMyAdmin through the SSH tunnel. Here, we have chosen PuTTY as the SSH client. Once the SSH client is configured successfully, you have to create an SSH tunnel as shown below:
- Navigate to Connection>SSH>Tunnel. Then, add a new forwarded port with the following values:
- Source port: 8888
- Destination: localhost:80
If the HTTP requests are going to be redirected to HTTPS port, use destination port 443. This creates a secure tunnel by forwarding the destination port on the remote server to the source port on the localhost.
- Next, click the “Add” button and secure tunnel configuration to the session. The added port will appear in the list of “Forwarded ports” as seen below:
- After that, save the changes by clicking the Save button in the Session section.
- Next, click the Open button and open as SSH session. This session includes a secure SSH tunnel between the two ports specified.
- Then, access the PhpMyAdmin console via the secure SSH tunnel by navigating to http://127.0.0.1:8888/phpmyadmin
- After that, log in using the following credentials:
- Username: root
- Password: application password
If access to phpMyAdmin is denied, check the the PuTTY event log to ensure the SSH tunnel was created or not.
Access PhpMyAdmin on MacOS and Linux
According to our Support Engineers, you have to create an SSH tunnel as shown below:
- First, open a new terminal window on the local system.
- Then, keep you SSH credentials or the .pem key file within reach.
- Next, configure the SSH tunnel with the SSH key file with these commands:
ssh -N -L 8888:127.0.0.1:80 -i KEYFILE bitnami@SERVER-IP
Replace SERVER-IP with the hostname or public IP address of the server and KEYFILE with the private key’s path. Also remember to change the destination port to 443 in case you are redirecting HTTP requests.
- After that, access the console via the secure SSH tunnel.
- Then, log in using the following credentials:
- Username: root
- Password: application password
[Need further assistance? Don’t hesitate to give us a call.]
Conclusion
At the end of the day, the Support Engineers at Bobcares showed us how to access PhpMyAdmin remotely over a secure SSH tunnel.
PREVENT YOUR SERVER FROM CRASHING!
Never again lose customers to poor server speed! Let us help you.
Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.
0 Comments