Re: Struglling - where to get help - cannot connect using forward engineering

[Mike Lischke]

Dave,

okay, your host could connect remotely, that means they have opened the port 3306 (which MySQL uses). You should do the same on your client machine (open in the firewall). To see if you can connect try telnet:

Wineyard:~ Mike$ telnet yourhost.net 3306
Trying "IPA Adress" ...
Connected to yourhost.net.
Escape character is '^]'.
>
5.1.30-community##~")Is)lf!=;Qg2cyX,ptsConnection closed by foreign host.

MySQL isn't made to work with telnet, but you can at least check if you can access your remote box from your local box. Once this works you should be able to connect to your db server using MA and WB. Make sure the user you use to connect to the server has the right to connect remotely, e.g. root@% (anyhost), not just root@localhost. Better though you create another user with only the necessary rights to make it work instead of allowing the root user to have access from anywhere. And use *good* passwords, but I guess you know that.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/