Installing MySQL on Windows

Installing MySQL on Windows

MySQL

Om MySQL te installeren voer het volgende uit. 

  • Open the IIS Manager and start the Web Platform Components Installer 
  • Select MySQL Windows 5.1 and press the Add button

  • Press install to install MySQL
  • Select a password for root (remember this for later use)

  • Accept the download

  • The download will start en will install the MySQL Server environment

Create a MySQL database

Analyze needs a database to save its data to. So for now we create a void database (database with no schema). Analyze will install the schema as it runs for the first time. 

To create a void schema, follow the next procedure: 

  • Open the MySQL Command Line Client

  • Enter the password and you will enter the MySQL console client. 
  • Create the database opdion-analyze, you can use any other name, remember to change that in the configuration files
create database `opdion-analyze`;
  • If all went well, this is what you will see as a result. 

  • end this application by entering quit and execute the command by pressing the enter key.