Question

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

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

Submit an answer

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!

Sign In or Sign Up to Answer

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.

Rajkishore J • July 19, 2022

Hi @evanomondi7,

Our below community article can guide you in setting up and connecting to MySQL Managed database via phpMyAdmin with SSL.

https://www.digitalocean.com/community/tutorials/how-to-connect-to-mysql-managed-database-via-phpmyadmin

I hope this helps!

Regards, Rajkishore

Bobby Iliev • 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