MySQL Instructions

  1. Open MySQL Workbench
  2. Open the desired connection (i.e. double-click on Local instance MySQL55)
  3. Click on Create a new schema in the connected server (third icon from left in the toolbar)
  4. Enter "clinic" for the Name
  5. Click on Apply
  6. Click on Apply in the Apply SQL Script to Database window
  7. Click on Finish
  8. Close the clinic - Schema tab
  9. Double-click the clinic schema in the sidebar
  10. In the Query 1 tab, click on Open a script file in this editor
  11. Select the clinic.sql file from this folder
  12. Click on the Execute the selected portion of the script or everything, if there is no selection icon (lightening bolt)
  13. Click on the Home tab (icon in the shape of a house)
  14. Click on Manage Security under Server Administration
  15. Click on Add Account in the Server Access Management tab (button near bottom-left of the MySQL Workbench window)
  16. Enter "clinic" for Login Name
  17. Enter and confirm the password for the account
  18. Click on the Administrative Roles tab
  19. Check the DBA tab
  20. Click on Apply (button near bottom-right of the MySQL Workbench window)
  21. Install Connector/Net, if not already installed
  22. Open the clinicMySQL.cfg file in this folder
  23. Replace the orange text in the following line with the password chosen in step 12:

    connectionString = "Data Source=localhost;Database=clinic;User Id=clinic;Password=password"

  24. Move the clinicMySQL.cfg file from this folder to the dbiScript\data folder
  25. In the dbiScript\apps\clinic\clinic.js file change the following line

    app.dbiScriptProperties.dataConfig = "../data/clinic.cfg"

    to

    app.dbiScriptProperties.dataConfig = "../data/clinicMySQL.cfg"

  26. Navigate to http://localhost/dbiScript/apps/clinic/