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 dev.mysql.com website.
Demonstration – Server-side
- Download the product here
- From MySQL Community Downloads, select ‘MySQL Installer for Windows’
![](/ContentData/2346-MySQL_L4_2_InstallerWin.png)
- Select the ‘mysql-installer-community’ version that will download all needed components for installation.
![](/ContentData/2347-MySQL_L4_3_WinDownload.png)
- Click on the download link on the following page
![](/ContentData/2348-MySQL_L4_4_DownloadLink.png)
- Once downloaded, click on the .msi file in the computer’s ‘Downloads’ directory to launch the installation wizard
![](/ContentData/2349-MySQL_L4_5_msiFile.png)
- In the installation wizard…
- Agree to the license agreement, and click ‘Next’
![](/ContentData/2350-MySQL_L4_5b_license.png)
- Select ‘Custom’ so that the desired components can be chosen, and click ‘Next’
![](/ContentData/2351-MySQL_L4_6_custom.png)
- 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
- 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
![](/ContentData/2352-MySQL_L4_7_selections.png)
- 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
![](/ContentData/2353-MySQL_L4_8_selections2.png)
- Click ‘Next,’ review the components list, click ‘Execute’ to install, and click ‘Next’ to configure the server
- Choose ‘Standalone MySQL Server / Classics MySQL Replication’ and click ‘Next’
![](/ContentData/2354-MySQL_L4_9_standalone.png)
- From the ‘Config Type:’ drop down menu, choose ‘Server Computer,’ leave all other default options in place, and click ‘Next’
![](/ContentData/2355-MySQL_L4_10_serverComp.png)
- Choose ‘Use Strong Password Encryption for Authentication (RECOMMENDED)’ and click ‘Next’
![](/ContentData/2356-MySQL_L4_11_strongPW.png)
- Enter a password into the two password fields and click ‘Next’
![](/ContentData/2357-MySQL_L4_12_enterPW.png)
- Leave all default setting in place for the ‘Windows Service’ screen and click ‘Next’
- The configuration is ready. Click ‘Execute’ and then ‘Finish’ once the configuration is successful.
- Click ‘Next’ when the configuration is shown as complete
- Confirm ‘Start MySQL Workbench after Setup’ is selected and click ‘Finish’ to complete the wizard and launch the Workbench
![](/ContentData/2358-MySQL_L4_13_finish.png)
- In the MySQL Workbench…
- The Workbench shows the connection to the local host that was just configured
- Click on the connection to access the server to configure
![](/ContentData/2359-MySQL_L4_14_connection.png)
- Enter the password that created during the server configuration, check ‘Save password in vault’ and click ‘OK’
![](/ContentData/2360-MySQL_L4_15_pw.png)
- 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
![](/ContentData/2361-MySQL_L4_16_serverStatus.png)
- Click on ‘Options File’ in the same panel
- Locate and check the ‘character-set-server’ box in the ‘International’ section
- Enter “latin1” in the ‘Specify default character set’ field
![](/ContentData/2362-MySQL_L4_17_options1.png)
- Locate and check the ‘collation-server’ box in the ‘International’ section
- Enter “latin1_general_ci” in the ‘Specify default collation’ field
![](/ContentData/2363-MySQL_L4_18_options2.png)
- Click ‘Apply’ twice and then ‘Yes’ to confirm the changes
![](/ContentData/2364-MySQL_L4_19_yes.png)
- Select the ‘Schemas’ tab in the ‘Navigator’ panel on the left to create the new database
- Note: in MySQL the terms “schema” and “database” mean the same thing
- Right click in the panel, and select ‘Create Schema’
![](/ContentData/2365-MySQL_L4_20_schemas.png)
- Enter the name of the new database/schema into the ‘Name’ field – “orderentry191”
- Select ‘latin1’ and ‘latin1_general-ci’ from the ‘Charset/Collation’ dropdown menus, so the match the settings made for the server
- Click ‘Apply’
![](/ContentData/2366-MySQL_L4_21_oe191.png)
- The SQL script that will be executed is shown. Click ‘Apply’ and then ‘Finish’
- The new database now appears in the ‘Navigator’ panel on the left
![](/ContentData/2367-MySQL_L4_22_database.png)
- Expanding the new database shows the default structure for any database that will be created.
Demonstration – Client-side
- To install the client, first open the Control Panel and click on ‘Programs and Features’
![](/ContentData/2368-MySQL_L4_23_programsFeatures.png)
- The needed connector, ‘MySQL Connector/ODBC 8.0’ is shown because it was part of the original package that was downloaded.
![](/ContentData/2369-MySQL_L4_24_odbc.png)
- 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
![](/ContentData/2370-MySQL_L4_25_connectorOdbc.png)
![](/ContentData/2371-MySQL_L4_26_32bit.png)
- Return to the Control Panel, and select ‘Administrative Tools’
![](/ContentData/2372-MySQL_L4_27_adminTools.png)
- Double-click on ‘ODBC Data Sources (32-bit)’
![](/ContentData/2373-MySQL_L4_28_odbc32bit.png)
- Click on the ‘Drivers’ tab, and select ‘MySQL ODBC 8.0 ANSI Driver’
![](/ContentData/2374-MySQL_L4_29_ansi.png)
- Click on the ‘System DSN’ tab, and click on the ‘Add’ button
![](/ContentData/2375-MySQL_L4_30_add.png)
- Select ‘MySQL ODBC 8.0 ANSI Driver’ and click ‘Finish’
![](/ContentData/2376-MySQL_L4_31_8ansi.png)
- Enter the details of the DSN in the following pop-up being sure to select the ‘orderentry191’ database that was created and click ‘Ok’
![](/ContentData/2377-MySQL_L4_32_parameters.png)
- The new DSN is now shown. Click ‘Ok.’