MySQL Installer Guide

Step: 1 Download & Install the MYSQL from the link given below

1. After clicking on the given reference URL, download the MySQL server.
   
2. Click on the Download button.

MySQL Download Window

1. Afterwards the "MySQL installer" file will download to your system.
2. Run the file on your system to proceed with the next steps.
3. Select the Custom option and click on the Next.

1. Select the version of MySQL Server, Workbench, Shell.
   
2. Click on the Next option.

Select Products Window

1. Check the Status of installed products.
   
2. Click on the Execute button to proceed.

Product Status Window

1. Proceed by clicking the Next button until the Password window appears.
2. Input your preferred password for the SQL Server and proceed by clicking the Next button.
   

MySQL Password: Root

Repeat Password: Root

Reference image:

User Password Window

1. Continuously click Next, Next, Execute, Finish, Next, Finish to reach the Installation Complete window.
   

Installation Complete Window

Step: 2 Copy MySQL File Folder Path

1. Go the file folder in your system where MySQL is installed.
2. Open MySQL> MySQL Server> Bin and Copy that file path as shown in the image below.
   

Copy File Path

1. In the system's search bar, enter Environment Variable and click Edit System Environment Variables option.
   
2. After that, click on the Open button.

Environment Variables

1. Next, click on the "Environment Variables" button.

1. In the Environment Variables window, first select the Path, then click on the Edit option.
2. After that click New button and paste the copied file path of the MySQL folder copied earlier in the blank column.
   
3. Click on the OK button.

Edit Variables Window

1. Enter Username, Password & DB Name and all details in the allscan-config. file which you can find in SwilERP's Folder.

1. For the Server then localhost will come inside host.
   
2. For the Client then IP Address of the server will come inside the host.

1. You have to Run the command prompt as follows:

1. mysql -u root -p  (To open the My SQL and enter password).
2. Create database ALLSCANS; (Create the database in MYSQL Server).
   

Command Prompts Window

1. Now, when you export the data in SwilERP Software you can see a table of AllScan products.

Data Configuration Window

Read More: How to Scan Product Batch Details with Zero Data Entry Process