Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Can't install php-soap to my PHP 7.0 centos Question Question
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question

Question

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

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

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Can't install php-soap to my PHP 7.0 centos Question Question
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm 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