MySQL Forums
Forum List  »  MySQL Workbench

Re: Connecting to remote server
Posted by: Mike Lischke
Date: March 24, 2014 03:02AM

The user and password combination you used in PMA will work in MySQL Workbench as well, the problem however is that PMA runs locally on your hosting server, while MySQL Workbench runs locally. So WB must connect via the standard MySQL server port (by default 3306) to your remote server. However, for security reasons this port is rarely open for connection and you have to open it also on your local and remote firewall.

Advanced users instead use SSH for remote connection. This is a secure channel and hence often open, also on a hosting package. It requires to have an SSH server on the remote end, however.

PMA works because it runs on the remote machine and therefore communicates locally with the MySQL server. Results are then sent via http which is always available on a web enabled hosting package.

You can do a little trick to check if you can reach your remote server with your current settings. Run a local command line with "telnet mysql11.host.net 3306". If that succeeds (some nonsense text comes back) then you can reach the server directly from your local box. If not then either your local firewall settings or that of the remote server do not allow traffic to go via port 3306. Finally, it could be that the MySQL server does not accept connections from non local addresses (solvable with an SSH connection).

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
1508
March 22, 2014 12:03PM
Re: Connecting to remote server
595
March 24, 2014 03:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.