Skip to content

1. MySQL Setup Guide

Shiva Prasad Adirala edited this page Mar 10, 2020 · 2 revisions

In this section will discuss on how to install MySQL server required for RF Historic report


Step 1: Download MySQL installer

  • Go to MySQL download page link

  • Click download as mentioned in image

    mysqldownload

Step 2: Install downloaded MySQL installer

  • Double click on mysql-installer-community-5.x.x.msi to install MySQL

  • Select Server only (for our requirement) and click Next as mentioned in image

    installtype
  • Continue with default settings (i.e., development and port) as mentioned in image

    sqlhost
  • Setup root user password (in my case password is 123456) as mentioned in image

    rootpassword
  • Continue other execution steps and click finish on completion


Authentication: Use legacy authentication

authentication

Step 3: Add MySQL path to PATH environment variable

  • Go to MySQL path: C:\Program Files\MySQL\MySQL Server 5.7\bin

  • Copy path

  • Add above copied path in PATH environment variable


Step 4: Validate MySQL installation

  • Open command prompt

  • Type mysql -uroot -p123456 and hit enter (following message should be shown)

    sqlinstalvali
  • Type show databases; and hit enter (following message should be shown)

    databases

You have successfully installed MySQL server which required for robotframework-historic