Related

Product App Platform: Run PHP apps without managing servers Product
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
doesn't work php session Question Question

Question

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

Posted April 5, 2021 60 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

Add a comment
evanomondi7
By:
evanomondi7

Related

Product App Platform: Run PHP apps without managing servers Product
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
doesn't work php session Question Question

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
bobbyiliev 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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help