JMC Next-Gen Web Server Install - Manual (Page 2)

2
After you choose the sql file to restore, you will be back to the Data Import/Restore screen, so click on Start
Import in the bottom right corner. Again, type in the root password and click on OK. It will start the import
process, and when it is done, you will get a screen which shows it was completed.
Now we want to create an account in MySQL Workbench that will be used to connect the JMC Web to the
SQL database so they can communicate. On the left side of the screen, click on Users and Privileges. Then
at the bottom, click on Add Account. In the middle right, type in the Login Name and Password you want to
use. We recommend you again use webjmc for the Login Name, and give it the same password you did for
the local webjmc user you created earlier on the server. In the section named Limit Connectivity to Hosts
Matching, change the % to localhost. Then click on Apply in the bottom right corner.
Now click on the Schema Privileges tab at the top, and then highlight your new webjmc user and click on
Add Entry… at the far right.
In the Schema Privileges window, we want to set the settings just as you see them in the left picture below for
both Selected host and Selected schema. Click OK.
At the next screen, click on Select “ALL” at the bottom, and then Save Changes at the bottom right corner.
The last thing we need to do is create a user to connect from a client computer(s) to the SQL database, so the
JMC POS and/or Form Designer applications can communicate. Still in the Users and Privileges section on