How can I connect my phpmyadmin to a remote managed database cluster

Posted on April 5, 2021

Hi, I setup a successfull phpmyadmin on a server but im having trouble connecting to a remote cluster as Im getting an error:500 after trying to copy this guys config: https://www.digitalocean.com/community/questions/trouble-connecting-remote-mysql-managed-database-to-one-click-phpmyadmin To setup phpmyadmin I followed this tutorial: https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Bobby

April 5, 2021

Hi there,

What I could suggest is to check your server logs to see what the actual error is rather than just the generic 500 error. If you are using Apache, you can find the logs here:

/var/log/apache2/error.log

Feel free to share the errors here.

Also I could suggest the following:

Make sure that you are using PHP 7.4 or 8.x
Make sure that you are using mysql_native_password for your MySQL user
Make sure to have the Managed database port opened on the server that you’ve installed PHPmyAdmin on

Let me know how it goes! Regards, Bobby