How to Install Your Own Local Multi-user Database

Remember: the Sumac team is happy to do this installation for you!

Some users may not feel comfortable installing a local multi-user database on their own. We highly recommend scheduling a time for a Sumac Guru to install your database for you.

Instructions for installing your own local multi-user Sumac database:

1. On your server computer, visit MySQL and download the MySQL 5.7 installer for your operating system.

2. Run the installer on the server computer.

3. When choosing the set-up type, choose “Custom.”

3. When selecting the “products” to install, select the 32 bit version of MySQL Server, and MySQL workbench.
Install Sumac

4. On the Type and Networking panel, select “Server Machine” for the configuration type.
Install Sumac

5. When creating the “root” user, give the user a password of “rootPwd”

6. Install any of the required dependencies you are prompted to install during setup, like Visual C++.

7. After the installation has completed, open MySQL workbench.

8. Click on the “localhost” instance, enter the root password (remember, you made this password “rootPwd” in step 5), and save it to the keychain.

8. Choose “Users and Privileges” on the left hand side, and then click New Account to create 2 new users with the following credentials:

User 1:
username: cfrUser
password: cfrPassword
location: localhost
Grant all permissions for this user.

User 2:
username: cfrUser
password: cfrPassword
location: %
Grant all permissions for this user.

9. After the users are created, you can now download Java and Sumac onto your server computer. Here’s how to do this:

Step 1: Go to and follow the instructions on that page to install the most recent version of Java installed on your computer, as well as the Sumac program.

Step 2: Run the Sumac installation. When prompted, click “I am a Customer,” then choose to connect to a “Multi-user database.”
Install Sumac

Step 3: Enter in your organization name and security code. The details of your organization name and security code will have been sent to you in a separate email. If you are having trouble locating this email, please contact the Sumac Team and we’d be happy to re-send it!
Enter the Host Name: localhost
Enter the Host Admin User Name: root
Enter the Host Admin User Password: rootPwd
Then create a database name.
Install Sumac