Re: Generate the relationship(Foreign/Reference) diagram of the table

[Mike Lischke]

Hey Joanne,
> 1) Create a new diagram and then use File ->
> Import -> Reverse Engineer MySQL Create Script to
> import the dump and create a diagram.
> Joanne-> My Reserse Engineer MySQL is grayed out.
> So couldn't select it at all.
> Why it is grayed out. Is there anything
> that I can enable it so I can select it

Did you create the new model first? The reverse engineering option is only available if WB is in the modelling section. I wrote you have to create a diagram, though I meant a model. Sorry for that.

> In the connection box for the field SSH HostName -
> I entered the ipaddress of the Linux server. and
> in the MySQL Hostname I also entered the ipaddress
> of the Linux server. Is this correct?

Almost. The MySQL server address is that seen from the target machine you connect to via SSH. Using SSH is like virtually moving over to the target box and work from there. So if the MySQL server is on the same box which you connected to via SSH then it is localhost or 127.0.0.1 what must be entered in the MySQL server field.

Hope this is clearer now,

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/