MySQL Forums
Forum List  »  MySQL Workbench

Re: Regarding sample database Sakila
Posted by: Mike Lischke
Date: May 02, 2016 02:45AM

Shilpa,

you never connect to a database (aka schema), but to a (RDBMS) server. So if you can already connect to your server (I don't see an attached image, so I can only guess) the first important step is done already. Now you have to set up the databases you want to have in that server beside the default ones. For sakila there are 2 scripts which you get when downloaded the sakila zip. You can load and execute them to get the sakila db created and filled (first run the schema sql then the data sql). Once this is done you should see the sakila schema appear in the schema tree (maybe click refresh if it doesn't appear automatically).

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
Re: Regarding sample database Sakila
614
May 02, 2016 02:45AM


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.