From the MySQL Workbench select File > Open SQL Script and navigate to the DBC-e07-MYSQL-HSD-Create-Tables.sql file (can be downloaded from the Blackboard). We will now create the table structure and import the data, which is relatively simple. At this point the database has been created, but it does not contain anything yet. Then right click on HSD and select Set as Default Schema. If the database does not show in the left panel, right click and do Refresh All. Then click Apply, Apply again, and Close. Under Default Collation select utf8 - default collation. In this example, we will be importing the Heather Sweeney Designs database so we will use as Schema Name HSD. Importing a DatabaseĪfter opening a connection in the Workbench, right click in the left panel and select Create Schema. Then start the MySQL Workbench and create a new MySQL connection by clicking on the plus and enter the following information (replace username and password with your information):Ĭonnection Name: .ĭo not change any of the other fields. Open the downloaded file and step through the installation process. Make sure that you download just the Workbench installer and not the MySQL installer (sometimes shown under recommended downloads), which contains other software besides the Workbench as well that you do not need and will only be confusing. Second, you have to use the MySQL Workbench to create a connection to MySQL, which is covered in this tutorial.ĭownload the MySQL Workbench from here. First, you have to use PuTTY or the Terminal to install and configure MySQL, which is covered in this tutorial. The two-step procedure to set this up is shown in the figure below. It is important to point out that MySQL has to be installed in your learning environment and the MySQL Workbench has to be installed on your local computer. This tutorial explains how to set up the MySQL Workbench. MySQL is a popular open source database and is often used in conjunction with the MySQL Workbench.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |