How to Setup MySQL Server for AllScan Process in SwilERP

How to Setup MySQL Server for AllScan Process

MySQL Installer Guide


For successful implementation of the Allscan process in SwilERP software, the initial step involves installing MySQL on your system. This article provides a detailed, step-by-step guide on setting up MySQL.

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.
Reference image:
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.
Reference image:

  1. Select the version of MySQL Server, Workbench, Shell.
  2. Click on the Next option.
Reference image:
Select Products Window
  1. Check the Status of installed products.
  2. Click on the Execute button to proceed.
Reference image:
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.
Note: Users can use the MySQL Root Password as given below:

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.
Reference image:
Installation Complete Window

Step: 2 Copy the 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.
Reference image:
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.
Reference image:
Environment Variables
  1. Next, click on the "Environment Variables" button.
Reference image:

  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.
Reference image:
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.
Reference image:

  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.)
Reference image:
Command Prompts Window
  1. Now, when you export the data in SwilERP Software you can see a table of AllScan products.
Reference image:
Data Configuration Window

      • Related Articles

      • Zero Data Entry with AllScan in SwilERP (RetailGraph)

        How to Scan Product Batch Details with Zero Data Entry Process SwilERP has introduced a solution with their new feature, AllScan. With zero data entry, you can now easily scan the product batch details via the AllScan mobile application and have it ...

      • SQL Server Service in Window 11

        How to Start SQL Server Service During Installing in Windows 11 Overview We recently encountered an issue with the SQL Server service not starting in Windows 11. The error is below-mention: If you have this type of issue while installing SQL, then ...

      • Setup Guide of SwilERP (RetailGraph)

        How to Setup SwilERP (RetailGraph) Software in your System Introduction of RetailGraph Introduce the RetailGraph as an all-in-one solution for the Retail and Distribution business. With RetailGraph, It is significantly easier to operate sales, ...

      • Zero Data Entry with AllScan in SwilERP

        How to Scan Product Batch Details with Zero Data Entry Process SwilERP has recently introduced AllScan, a revolutionary feature that enables users to effortlessly scan product batch details via the AllScan mobile application. The AllScan feature ...

      • Online Setup Process For SwilERP (RetailGraph)

        How to Set Centralized Online Working with SwilERP (RetailGraph) In RetailGraph, you can set up centralized online working. With this process, users have only one database, and they can create multiple branches of stock locations . But the users ...