Hi,
I know MySQL Workbench isn't supported by cPanel, however we have a remote SQL server environment from main Web/Email servers and we are unable to connect to the MySQL with Workbench - We were curious whether anybody had succeeded with this.
When we connect to a domain, with the cPanel username and password we get the error "Host ****** is not allowed to connect to this MySQL server" - I then had a browse and of course, added the Wildcard under Remote Hosts on cPanel, tried again. Still no luck.
We then tried connecting directly to the remote MySQL server, this did not work either - Error 10060.
We are running CSF Firewall on all servers, but the relevant ports are open to enable SQL connectivity.
Any suggestions/ideas would be greatly appreciated.
Thanks,
James
I know MySQL Workbench isn't supported by cPanel, however we have a remote SQL server environment from main Web/Email servers and we are unable to connect to the MySQL with Workbench - We were curious whether anybody had succeeded with this.
When we connect to a domain, with the cPanel username and password we get the error "Host ****** is not allowed to connect to this MySQL server" - I then had a browse and of course, added the Wildcard under Remote Hosts on cPanel, tried again. Still no luck.
We then tried connecting directly to the remote MySQL server, this did not work either - Error 10060.
We are running CSF Firewall on all servers, but the relevant ports are open to enable SQL connectivity.
Any suggestions/ideas would be greatly appreciated.
Thanks,
James