Module 6 - Lab: Database Connectivity
CIS355
How to use MySQL Inside Azure DeVry University College of Engineering and Information Sciences
Preparation (has to be done before you start working on your query)
1. Login to your VM and open MySQLWorkbench.
Click MySQL Workbench
2. Close the welcome screen. Double-click on the local instance.
3. Enter password devry123.
devry123
4. You are now inside your SQL editor and ready to create a new SQL schema (database). Click on the fourth icon to create a new schema.
Click the fourth icon to create a new schema.
5. When the window pops out, name your schema, then click Apply.
Name your schema here.
6. On the next review SQL script window, click Apply again.
Click
7. On the next applying page, click Finish.
Click
8. On your navigator window, you can now see your newly created schema.
Verify that your schema is created.
9. Click the first icon to create a new SQL tab for executing queries.
Click
10. Now we have the SQL editor ready for executing queries. Let‘s make sure we are working under the default schema. Right-click the schema to set it as default schema.
Set default schema first.
11. Now you are ready to write queries into the SQL editor window.
12. Execute the script by clicking the symbol
Click
Page 4 of 4