Remote Administration is not a single switch you can toggle, its a number of settings you have to edit to allow WB to remotely access your server.
For remote administration you need:
1) A connection to a remote MySQL server. This can be pure TCP/IP (which requires to open port 3306 or any other you have set for your MySQL server) or TCP/IP over SSH (which only requires port 22 and encrypts the communication.
2) A remote "command connection", which is either a remote secure shell (another SSH connection) or WMI (for Windows).
Point 1 is set up in the Connection Manager (left column, last entry on the WB home screen). Alternatively you can use the New Connection Wizard (click the "New Connection" link in that column.
Point 2 is set up in the Server Instance Manager (which btw allows to set up a connection like in point 1 too, but this is not important at the moment). The instance manager can be reach via the last link in the right column on the WB home screen. Alternatively you can also use the New Server Instance Wizard (the link should be obvious).
When you open the server instance manager for an existing server instance, you will see a block of settings titled "Remote Adminstration" (select your instance in the left-hand list first). There are the 3 possible type settings (none, win-based, ssh-based) and obviously either win-based or ssh-based should be set for your instance. When you want an ssh-based remote management then adjust the SSH settings to make this work. These settings are *not* the ones from the MySQL connection (two different SSH connections, one is for port fowarding only, the other for a true remote shell). However, usually the SSH settings (server, port, user, pw) are the same for both connections.
Once this is all adjusted you should be able to use WB Adminstration for your server. If you still have trouble with that server instance I recommend to start over using the New Server Instance Wizard to create a new connection. The wizard will do some checks to make sure the parameters are ok.
Also, see more resources:
http://forums.mysql.com/read.php?160,252640
HTH
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/
Edited 2 time(s). Last edit at 03/25/2011 07:21PM by Edwin DeSouza.