Question

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

Posted April 5, 2021 397 views
PHPDigitalOcean Managed MySQL Database

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

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.

×
Submit an Answer
1 answer

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