To continue with this content, please log in with your Data Access ID or create a new account.
Cancel Data Access ID
You may not be authorized to see this content. Please contact Data Access Europe for more information.
Cancel Data Access Europe
You are not authorized to see this content.
Cancel Data Access Europe
Next lesson:
DataFlex Environment

Migrating to MySQL Environment

Lesson 4: Setting up the MySQL Environment

The necessary software needs to be obtained before setting up the environment. Installation programs can be downloaded the website. 

Demonstration – Server-side

  1. Download the product here
  2. From MySQL Community Downloads, select ‘MySQL Installer for Windows’
  3. Select the ‘mysql-installer-community’ version that will download all needed components for installation.  
  4. Click on the download link on the following page
  5. Once downloaded, click on the .msi file in the computer’s ‘Downloads’ directory to launch the installation wizard
  6. In the installation wizard…
  7. Agree to the license agreement, and click ‘Next’
  8. Select ‘Custom’ so that the desired components can be chosen, and click ‘Next’
  9. Fully expand the ‘MySQL Servers’ branch, select ‘MySQL Server 8.0.17 -X64,’ and click the right arrow to move it into the ‘Products/Features To Be Installed’ panel
  10. Expand ‘Applications > MySQL Workbench > MySQL Workbench 8.0,’ select ‘MySQL Workbench 8.0.17 – X64,’ and click the right arrow to move it into the ‘Products/Features To Be Installed’ panel
  11. Expand ‘MySQL Connectors > Connector/ODBC > Connector/ODBC 8.0,’ select the 32-bit connector ‘Connector/ODBC 8.0.17 – X86,’ and click the right arrow to move it into the ‘Products/Features To Be Installed’ panel
  12. Click ‘Next,’ review the components list, click ‘Execute’ to install, and click ‘Next’ to configure the server
  13. Choose ‘Standalone MySQL Server / Classics MySQL Replication’ and click ‘Next’
  14. From the ‘Config Type:’ drop down menu, choose ‘Server Computer,’ leave all other default options in place, and click ‘Next’
  15. Choose ‘Use Strong Password Encryption for Authentication (RECOMMENDED)’ and click ‘Next’
  16. Enter a password into the two password fields and click ‘Next’
  17. Leave all default setting in place for the ‘Windows Service’ screen and click ‘Next’
  18. The configuration is ready. Click ‘Execute’ and then ‘Finish’ once the configuration is successful. 
  19. Click ‘Next’ when the configuration is shown as complete
  20. Confirm ‘Start MySQL Workbench after Setup’ is selected and click ‘Finish’ to complete the wizard and launch the Workbench
  21. In the MySQL Workbench…
  22. The Workbench shows the connection to the local host that was just configured
  23. Click on the connection to access the server to configure
  24. Enter the password that created during the server configuration, check ‘Save password in vault’ and click ‘OK’
  25. Click ‘Server Status’ from the ‘Administration’ tab in the ‘Navigator’ panel on the left to show the current server configuration settings and the locations of the pertinent files
  26. Click on ‘Options File’ in the same panel
  27. Locate and check the ‘character-set-server’ box in the ‘International’ section
  28. Enter “latin1” in the ‘Specify default character set’ field
  29. Locate and check the ‘collation-server’ box in the ‘International’ section
  30. Enter “latin1_general_ci” in the ‘Specify default collation’ field
  31. Click ‘Apply’ twice and then ‘Yes’ to confirm the changes
  32. Select the ‘Schemas’ tab in the ‘Navigator’ panel on the left to create the new database
  33. Note: in MySQL the terms “schema” and “database” mean the same thing
  34. Right click in the panel, and select ‘Create Schema’
  35. Enter the name of the new database/schema into the ‘Name’ field – “orderentry191”
  36. Select ‘latin1’ and ‘latin1_general-ci’ from the ‘Charset/Collation’ dropdown menus, so the match the settings made for the server
  37. Click ‘Apply’
  38. The SQL script that will be executed is shown. Click ‘Apply’ and then ‘Finish’
  39. The new database now appears in the ‘Navigator’ panel on the left
  40. Expanding the new database shows the default structure for any database that will be created.

Demonstration – Client-side

  1. To install the client, first open the Control Panel and click on ‘Programs and Features’
  2. The needed connector, ‘MySQL Connector/ODBC 8.0’ is shown because it was part of the original package that was downloaded.
  3. If it needs to be downloaded for installation at another location, return to this page and select ‘Connector/ODBC, and choose to download the 32-bit Windows version
  4. Return to the Control Panel, and select ‘Administrative Tools’
  5. Double-click on ‘ODBC Data Sources (32-bit)’
  6. Click on the ‘Drivers’ tab, and select ‘MySQL ODBC 8.0 ANSI Driver’
  7. Click on the ‘System DSN’ tab, and click on the ‘Add’ button
  8. Select ‘MySQL ODBC 8.0 ANSI Driver’ and click ‘Finish’
  9. Enter the details of the DSN in the following pop-up being sure to select the ‘orderentry191’ database that was created and click ‘Ok’
  10. The new DSN is now shown. Click ‘Ok.’