Skip to main content

Installing MySQL Server with Workbench

Contents​

Obtaining MySQL Server + Workbench​

  1. Go to the download section of the MySQL website and select the downloads option.
  2. Select the latest version of MySQL Installer for Windows.
  3. Download the Windows (x86, 32-bit), MSI Installer (mysql-installer-community-xxx.msi) installer. It's recommended you download the full size installer and not the web installer.

Installing MySQL Server + Workbench​

Run the installer and follow the instructions below:

  1. Select the custom setup type. Choosing_a_setup_type
  2. For products, expand down the directory tree till you have the latest version my MySQL and the latest version of Workbench selected. Press the green right arrow to mark them for installation, as presented below: Selecting_products
  3. Execute the installation and wait for the process to finish. Press next when complete.
  4. Press the next button to be bought to the configuration for your MySQL server. MySQL_installation

Configuring your MySQL server​

Type and Networking:​
  1. Select Server Computer in the Config Type: dropdown box.
  2. Enable TCP/IP.
  3. Enter 3306 in the port field.
  4. Enter 33060 in the X Protocol Port field.
  5. Enable Open Window Firewall port for net work access.
  6. Leave Named Pipe as disabled. This will set the Pipe name to MYSQL.
  7. Leave Share Memory as disabled. This will set the Shared Memory as MYSQL.
  8. When your settings match the below screenshot, press next to continue. mysql_server_type_and_networking
Authentication Method:​
  1. Select the Use Legacy Aithentication Method (Retain MySQL 5.X Compatability) option.
  2. When your settings match the below screenshot, press next to continue. mysql_server_authentication_method
Accounts and Roles:​
  1. Enter tntnet into the MySQL Root Password field. Repeat this in the Repeat Password field below. mysql_server_accounts_and_roles_1
  2. Press the Add User button.
  3. Create a user with the following details. The username should be tim. The password should be tntnet with MySQL authentication. They should have the DB Admin role. mysql_server_accounts_and_roles_2
  4. When your settings match the below screenshot, press next to continue. mysql_server_accounts_and_roles_3
Windows Service:​
  1. Enable Configure MySQL to run as a Windows Service.
  2. Name the MySQL service MySQL80.
  3. Enable **Start the MySQL Server at System startup.
  4. Select the service to run as Standard System Account.
  5. When your settings match the below screenshot, press next to continue. mysql_server_windows_service
Server File Permissions:​
  1. Select the Yes, grant full access to the user running the Widows Service and the administrators group only. Other users and groups will not have access. option.
  2. When your settings match the below screenshot, press next to continue. mysql_server_file_permissions
Apply Configuration:​
  1. Press the Execute button to apply the settings we have configured. When complete you should see something similar to the below screenshot:
  2. Press the next button to finish the installation. You will be asked to launch MySQL Workbench, enable this option and press finish.

Configuring your MySQL Workbench​

  1. Once loaded into Workbench, log in with the root credentials listed previously.
  2. Select the Schemas tab, then right click in the white space below >sys and select create schema. workbench_create_table_1
  3. Name the schema timenterprise and press apply.img/workbench_create_table_2.png workbench_create_table_2
  4. An Apply SQL script to database window will be displayed. Press the apply button and wait for it to finish. workbench_create_table_3
  5. Press the finish button to execute the query. workbench_create_table_4
  6. Now you should be able to see the new schema created in the schema list.
  7. Select the Administration tab, then select Status and System Variables.
  8. Select the System Variables tab, then enter sql_mode into the search box. mysql_server_strict_mode_2
  9. Enable the Persist option.
  10. Click in the text fields for both the Value and Persist Value and enter the following:STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION. The default values for both fields are: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
  11. Your options should now be updated and look like the following screenshot: mysql_server_strict_mode_3

Install MySQL Connector/ODBC driver​

  1. Run the installation package.
  2. Press the next button. odbc_1
  3. Choose the Typical installation. odbc_2
  4. Press the Install button to carry out the installation. odbc_3
  5. Press the Finish button to finish the installation. odbc_4.png