My phpmyadmin stopped working after I switched to SSH public key
Linode
Linode Staff
Connecting through Putty on a Windows 7 machine.
Trying to go to <my address="" ip="">/phpmyadmin through my browser returns this error:</my>
"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
I'm assuming since I switched to using public key authentication i've closed off access to my phpmyadmin. How do I access it? I tried creating an SSH tunnel in Putty with source port 8888 and destination localhost:80 but it hangs when i try to go to <my address="" ip="">:8888/phpmyadmin</my>
1 Reply
rgerke
Linode Staff
Hi there,
In looking at the steps you performed, it looks like you're on the right track with your configuration with just a few changes needed.
In the PuTTY Configuration destination field, you'd need to put this: 127.0.0.1:8888
When you're trying to access phpmyadmin in your browser, you would resolve it to the following, as 127.0.0.1 (and not your Linode's IP) is the IP you'd always need to use to remotely connect to your phpmyadmin:
http://127.0.0.1:8888/phpmyadmin
If you take a look at our guide on setting up a tunnel through PuTTY, you'll see that it directs you to utilize that 127.0.0.1 address instead of your own IP. If you've set everything up correctly, you should be able to resolve to the phpmyadmin login screen by using the above domain.
This works in a similar fashion to the configuration for a MySQL tunnel, but you would use port 8888 instead of what's given in the example I'm linking to you below. Keep in mind that this guide is for MySQL and not phpmyadmin, but it operates on the same principal.