Running SalesMate + with MySQL Server

How to Install MySQL Server on Windows for SalesMate+

Q: Why would I use MySQL with SalesMate+ instead of the default database?

Using MySQL allows SalesMate+ data to be stored in a centralized, networked database , improving support for multi-user environments , backup procedures, reporting, and performance across multiple client machines. This setup provides better scalability than the internal default database.

To run SalesMate + with a MySQL database backend on a Windows PC, you must first install and configure MySQL Server. MySQL acts as the database engine that stores SalesMate+ data when used in a multi-user or centralized setup instead of the default internal database.

1. Download the MySQL Installer

Open your web browser and go to the official MySQL downloads page:
https://dev.mysql.com/downloads/installer/
Download the MySQL Installer for Windows (choose the full installer if possible).

The full installer includes MySQL Server, MySQL Workbench, ODBC drivers, and other useful tools.
The smaller “web” installer may require internet access during installation and might not include all components.

2. Run the MySQL Installer

Double-click the downloaded .msi file to start the MySQL Setup Wizard.
Accept the License Agreement and click Next.
When prompted for Setup Type, choose one of the following:
- Developer Default – installs MySQL Server, Workbench and tools; recommended for most users.
- Custom – lets you manually select packages (e.g., Server, ODBC driver).
Click Execute to download and install the selected components.

The installer will show progress and handle prerequisites automatically.
On completion, it proceeds to configuration steps.

3. Configure the MySQL Server

Once the core MySQL software is installed, you need to configure the server instance:

In the installer Product Configuration screen:
- Choose Standalone MySQL Server / Classic MySQL Replication.
- Set the Config Type to Development or Server Machine based on your usage.
Choose a root password and optionally create additional database users.
- Make a note of this password — SalesMate+ will need the database credentials to connect.
Configure the port (default is 3306).
Enable MySQL as a Windows Service so that it starts automatically on system boot.
Complete the configuration and start the MySQL server.

4. Verify MySQL Server Installation

To ensure MySQL Server is running:

Open Command Prompt (cmd).
Run the MySQL client:
```
mysql -u root -p
```
Enter the root password you set earlier.
If you see the MySQL prompt (mysql>), the server is running successfully.
Optionally, use MySQL Workbench (installed with the server) to visually inspect the server, manage users, and perform administrative tasks.

5. Configure SalesMate+ to Use MySQL

After MySQL Server is installed and running:

Open SalesMate+ Setup on your Windows PC.
Go to the Database Configuration / Connection screen.
Choose MySQL as the database type.
Enter the following details:
- Server/Host: localhost (or IP address if remote)
- Port: 3306 (unless you changed it)
- Database Name: (create a new database for SalesMatePlus if not already created)
- Username / Password: The MySQL user credentials you created
Save settings and test the connection.

SalesMate+ will establish a connection to MySQL and initialize the required tables.
If the connection succeeds, your SalesMate+ installation will now use MySQL as its database engine.

Tips & Notes

Ensure you install the MySQL ODBC Driver if SalesMate+ uses ODBC to connect to MySQL.
For multi-user environments, ensure the MySQL server machine has stable network connectivity and that the Windows firewall allows port 3306.
If you encounter connection issues, verify that the MySQL service is running and the credentials are correct.

SalesMatePlus | MySql | FAQ

+What does “Running SalesMate + with MySQL Server” mean?

“Running SalesMate + with MySQL Server” refers to configuring SalesMate + GST Billing Software to use a MySQL database as its backend server database instead of the default local database. This setup is useful for users who want centralized data storage and higher performance in multi-user or enterprise environments.

+How do I install MySQL Server for use with SalesMate+?

To install MySQL Server on Windows for SalesMate+, download the MySQL Installer from the official MySQL website, run the installer, and choose the appropriate setup type (Developer or Custom). After installation, configure the server instance with a root password and ports (default 3306). MySQL can then be set as a service to start automatically

+What configuration steps are needed to connect SalesMate+ to MySQL?

After installing MySQL Server and ensuring it’s running, open SalesMate+ Setup, go to the Database Configuration/Connection screen, choose MySQL as the database type, and enter your host/port, database name, username, and password. Then save and test the connection to complete the setup.

+Why would I use MySQL with SalesMate+ instead of the default database?

Using MySQL allows SalesMate+ data to be stored in a centralized, networked database, improving support for multi-user environments, backup procedures, reporting, and performance across multiple client machines. This setup provides better scalability than the internal default database.

+What prerequisites or tips should I know before using MySQL with SalesMate+?

Make sure MySQL Server is installed with tools like Workbench and ODBC drivers if needed. Ensure the MySQL service is running and firewall settings allow access on the configured port (commonly 3306). Also verify credentials and that the database exists or can be created by the SalesMate+ connection setup.