Report this

What is the reason for this report?

Trouble connecting remote mysql managed database to one-click phpmyadmin

Posted on May 6, 2020

Good Morning,

I created a mysql managed database (open to all incoming connections/raw initial setup). I then created a one-click phpmyadmin droplet from the marketplace, as I would like to create a web-based ui for managing my mysql managed database as I use chrome os more often than not, and would prefer to not use desktop apps for accessing and managing my databases/web projects in general and keep my development process browser-based.

I then updated the phpmyadmin mysql to mysql 8, and tried to add the managed database server to the /etc/phpmyadmin/config.inc.php file. i.e.: $i++; $cfg[‘Servers’][$i][‘verbose’] = ‘CLUSTER’; $cfg[‘Servers’][$i][‘host’] = ‘nottheprivatehost-0.db.ondigitalocean.com’; $cfg[‘Servers’][$i][‘port’] = 25060; $cfg[‘Servers’][$i][‘socket’] = ‘’; $cfg[‘Servers’][$i][‘auth_type’] = ‘config’; $cfg[‘Servers’][$i][‘ssl’] = true; $cfg[‘Servers’][$i][‘user’] = ‘doadmin’; $cfg[‘Servers’][$i][‘password’] = ‘mypassword’;

However, no matter what I add or modify, I cannot get the new server database to appear anywhere on ip/phpmyadmin when logging in or when logged on.

My primary question would be what I am missing in terms of the connection details for the config file or if I need to update another file somewhere or something else I am missing completely.

But also if anyone has any recommendations about better alternatives then phpmyadmin for a browser-based database manager ui for mysql, that would be some-what easy for a novice like myself to install and use, I wouldn’t mind going that route either.

I do like phpmyadmin and am familiar with it, and figured the one-click is decent enough to use.

Any help and/or guidance would be much appreciated.

Thank you,

-Matt

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.