I am trying to connect remotely to a MySQL server on webmin (VPS) and I cannot connect to host unless I am connecting using localhost. It is not possible with remote hosts.
The MySQL server is on webmin version 1.994 and virtualmin 7.1-1(Ubuntu Linux 20.04.4 is the operating system).
Port 3306 (TCP) is opened on the firewall. When I try connecting using MySQL workbench I get the error Your connection attempt failed for user ‘user’ to the MySQL server at xxxxxxxx:3306 unable to connect to localhost.
It happens also when I connect as the root user. I can connect without any problem using phpMyadmin.
I have tried browsing for solutions but I am not able to get a solution. Any help or direction would be greatly appreciated.