Question

Having issue with connecting DB cluster with phpmyadmin

Posted April 27, 2021 440 views
PHPDigitalOcean Managed MySQL DatabaseCentOS 8

I have installed phpmyadmin in my centos8 droplet, and created an db cluster with same private network, I could connect db cluster through centos8 droplet terminal, however, I couldn’t use phpmyadmin to connect the db cluster.

I am using a “Legacy – MySQL 5.x” user to connect, and I have the following in my config.inc.php:

$i++;
$cfg[‘Servers’][$i]['host’] = 'private-db01-xxxxxx.ondigitalocean.com’;

How make this work? What am I missing?
Thanks

1 comment

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,

In your PHPmyAdmin config, you need to also specify the database port as the Managed Databases run on a non-standard port.

Another thing that could be causing the problem is if you’ve installed PHPmyAdmin with apt install phpmyadmin, as this installs a very old version of PHPmyAdmin which is not compatible with the latest MySQL version.

Instead, you could install PHPmyAdmin manually and get the latest version:

https://www.digitalocean.com/community/questions/how-to-install-manually-phpmyadmin-on-ubuntu

Let me know how it goes.
Regards,
Bobby

  • Dear Bobby,

    Thanks for the phpmyadmin setup guide, its very detail and clear. I was following another manual install guide on the internet somewhere too, not using apt install phpmyadmin, however I found out that the issue is on apache:

    Apache was not configured for external access.

    sudo setsebool -P httpd_can_network_connect 1
    
    

    After running this command the issue was solved. Didn’t know about apache has this kind of configuration before.

    • Hi there,

      No problem at all! Happy to hear that you’ve got it all working.

      Thank you for sharing the command here with the community as well!

      Regards,
      Bobby