Level 75
Mar 12, 2022
5
Level 3
MySQl Workbench Connect to DigitalOcean
Pardon the newb question, though I have Googled this and read a few articles, I'm still at a loss, but thankful for this community I can reach out to.
I am trying to connect MySQL Workbench to my Droplet on DigitalOcean and I can't get it to connect. Tried Standard TCP/IP over SSH but it isn't working. What resource can you point me that will be current instructions on how to connect properly?
Level 3
@jlrdw Would you suggest using MySQL Workbench, or just installing PHPMyAdmin and using that instead? I'm used to PHPMyAdmin, which I know is a more novice tool, but I thought I would ask your opinion.
Level 75
@WallyJ I've never used it that way but I do like phpmyadmin better also.
Level 3
Well, I went ahead and tried to install PHPMyAdmin on my DigitalOcean droplet and now when I try my domain, it says:
app.mapqot.com refused to connect. Try:
Checking the connection Checking the proxy and the firewall ERR_CONNECTION_REFUSED
So I'm very confused. And my online app is down.
EDIT: I figured out that somehow Apache started running on my server instead of Nginx. I shut down apache and started nginx and all is well. Still not sure what this had to do with installing, or trying to install phpmyadmin.
Level 102
@WallyJ apache might get reenabled every time you update something. I personally uninstall it to make sure it does not happen again
sudo apt purge apache2
Personally I connect using dbeaver and ssh. You give it the private key location, ip and user. You also should remap the ports under advanced to avoid port collisions. If you change the port, but sure to change it in the connection settings as well
Please or to participate in this conversation.