Trouble connecting remote mysql managed database to one-click phpmyadmin
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.:
$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.
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.×