MySQL 5.7 for Windows


MySQL 5.7 updates installers for Windows and some of the syntax for typical changes needed to share data from your Big Buisness Server to shipping workstations running UPS WorldShip, FedEx Ship Manager, and so on.

This Solution provides details. (6655)






To Update:

1. Download an MSI installer from mysql.com.

2. Run the installer to install MySQL as Developer (low memory usage) or better.

3. Enter the Password for Root found in Big Business, Company Card, Upgrade, Middleware Shipping.

4. Add a user for shipping.

5. Set MySQL as a Service that starts automatically and runs on Standard System Account.

If changes are needed:
CD "C:\Program Files\MySQL\MySQL Server 5.7\bin\"
MySQL.exe -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
CREATE USER 'shipper'@'%' identified by 'MyNewPass';
GRANT ALL on *.* to "shipper"@"%";

And you can rely on Unlimited Setup Support included with Big Business for any help needed.



Related:

  Chapter 24 Middleware

Return to Help