As WipeDrive, Detalys, and Hardware Inventory can save the results of their operation directly to a SQL database, we decided to provide a basic manual with instructions on how to set up a MYSQL Server Express in your Windows machine.
These instructions will apply for Windows 10 Pro, Windows Server 2019 and 2016, but might not be limited to those versions.
Your SQL server must be accessible from any machine you want to save the log. In this manual, we will not mention any IP settings because that will depend on your environment and network layout.
- You will need to download the MySQL installer. There is a free Community edition of the MySQL installer from their official page. This can be found at. https://dev.mysql.com/downloads/installer/
- For our purposes we will be downloading the Full MySQL Package, this should be the second option. Once you select the download a page will pop up saying “Login” and “Sign Up” Under those two options there will be an option saying, “No thanks, just start my download” Click on this and the download will start.
Set Up MySQL for Windows
- After the installation has finished, run the program. You will be prompted to accept the Oracle license agreement, after doing so, you can choose a predefined option or create a custom set up. For this we are going to choose the option “Developer Default” option. This will allow us to have all the tools needed to develop and manage the MySQL database. After selecting the option click next.
- The next screen we see is Path Conflicts These options can be left alone, just hit ‘next.’
- In the installation screen you will need to press the execute button this will install the MySQL server. After it is complete you may press next. Here you may get an error saying that you need to install “MySQL for visual studio” That can be downloaded here: MySQL :: Download MySQL for Visual Studio
- Continue to press next until the Type and Networking screen shows up. On this screen we want to enable the “Show Advanced and Logging Options, this will be the last option on the screen. Leave the rest alone and press next.
- On the Authentication Method screen, we recommend keeping the “Use Strong Passwords” option. Select next and it will ask you to set a password for the database.
- Continue to press next through the next few screens until you reach the “Apply Configuration” screen. On this screen press execute to apply all settings. After the execution is complete press “Finish”
Installing MySQL tools
After completing the installation process, we will need to create the tools to help create the database.
- First, we will see a screen with our server installed, click on the server, and press the add button. Here we will install the necessary tool that comes with the MySQL database. The options we will want are MySQL Workbench, MySQL shell, and MySQL Router. You can add them by selecting them and pressing the green arrow on the screen. Press Next after they are added. After that you will need to press the execute button to install the software.
- After the installation is complete press, next this will bring you to the MySQL router configuration. Leave these options as they are and press finish. Click next after that and then finish. After you press finish the MySQL workbench will pop up. Here is where we can start making the database
Creating the Database
With the MySQL Sever and Tools installed, we can create the database and initialize it with the Wipe Drive Initializer tool.
- In the MySQL workbench, you will want to go to the tab that says ‘databases’ and click connect to database. This will bring up the connect to database wizard here there are a few settings we need to configure. You can leave most of the options alone and press ‘ok’ after pressing okay it will prompt you for a password, this is the same one you set up earlier.
- You should now be connected to the database and now you need to create a database schema. You can do this by pressing the icon that has 3 circles stacked on top of each other. This will be the 4th icon over. Name the schema how you would like, and press ‘apply’
3)After pressing apply, it will show a screen where it asks you to review. You can go ahead, and press ‘apply’ and then ‘finish’
4) At this point we can initialize the database with the Wipe Drive initializer tool, more on that can be found here Setting Up an Existing SQL Database for use with WipeDrive : WipeDrive
5) After the initializer has finished populating the database you can now save your logs to the newly made database.