Is it possible remote access mysql via Standard TCP on Workbench (without ssh)?
My droplet is connected via ssh, i also have a firewall ufw installed.
What i tried:
Change bind address from mysql configuration file to my droplet IP, also tried change to 0.0.0.0 for accepting request from any IP.
nano /etc/mysql/my.cnf ( Configuration file )
In ufw i allowed 3306/tcp for ipv4 and ipv6, if i run
sudo ufw status it is looking like
3306/tcp | ALLOW | Anywhere
3306/tcp | ALLOW | Anywhere (v6)
Still can’t access mysql via Workbench with standard tcp. Am i forgetting something?
Should i do expose mysql port with nginx or someting like that?