Call Us Today! 1 (866) 755-5465

LinkConn Database Creation

//LinkConn Database Creation
LinkConn Database Creation 2018-02-09T18:56:26+00:00

For users of the iGrow 1800 and LinkConn 1800 software, in order for your PC to effectively collect and store the data produced by LinkConn 1800 software, Link4 advises MySQL Database Server and MySQL Workbench to be used. This will eliminate the need to continually create new databases and regularly have to save your information.

Link4 has created this tutorial as a step-by-approach to help you install the MySQL Database Server and the MySQL Workbench on the PC being used with the LinkConn 1800 software. If you do not already have MySQL running in conjunction with your Link4 System, please install My SQL per the following instructions:

Note: Make sure that the latest version of Link1800 is installed before you follow this manual.

1. Visit https://dev.mysql.com/downloads/installer/ and click on download alongside the complete MySQL MSI Installer (non-web). Select your corresponding operative system to download the MySQL Community Server installer.

2. Click on No thanks, just start my download.

3. Locate the downloaded MySQL installer file and open the file to proceed with the installation.

4. If you see Upgrading community on the top left, please close the window, and open the MySQL Installer application from the start menu on your windows PC.

5. To proceed you must read and accept the Oracle Software License Terms.

6. Select option “Server only” and continue.

7. Check requirements (if any) and install.

8. No changes need to be made, continue.

9. No changes need to be made, continue.

10. Select option “Standalone MySQL Server / Classic MySQL Replication” and continue.

11. Select “Server Machine” in Config Type option and set all the other fields as shown:

12. Enter a password for the account or leave blank this section, continue. Enter desired username and password for the MySQL database. Default Username: root

13. No changes need to be made, continue

14. No changes need to be made, continue.

15. No changes need to be made, continue.

16. Click on finish to apply the configuration.

17. No changes need to be made, continue.

18. Click on finish to complete the installation.

19. Locate the installer file and open MySQL Installer again using Start > MySQL Installer Community.

20. Click on Add to incorporate the workbench

21. Expand the options and select MySQL Workbench, click on the green arrow and continue to install the Workbench

22. Click on execute to install.

23. No changes need to be made, continue.

24. Finish the installation.

25. MySQL installer now will show MySQL Workbench.

26. Open MySQL Workbench, click on Local Instance, and enter the password that was set in step 12 (MySQL Root Password).

27. Click on file, Run SQL Script, and look for the file “install-mySQL.sql” in the address C:/LinkConn1800communication/database/install.

28. Type in Schema Name and click on run. This is the Database name and it’s up to the user. DO NOT INCLUDE SPACES OR SPECIAL CHARACTERS IN THE DATABASE NAME.

29. After is completed, close the popup box and check on left hand corner under schemas if your database name is seen. If not, right click and hit refresh.

30. Close Workbench.

31. Open LinkConn Database Manager and click on Add Connection.

32. Type the name of the connection (up to the customer), select MySQL Simple, and click on Next.

33. Enter your database name as in step 28 (Default Schema Name), type username and password for the database as in step 12 (MySQL Root Password), and click on save. Do not change host or port unless needed.

34. Open LinkConn 1800 Communication Control Panel and click on Settings.

35. Change the Database Driver to “MySQL” and fill the fields Database, Username, and Password as in steps 12 (MySQL Root Password) and 28 (Default Schema Name). Click OK.

36. User is ready to use MySQL as backend for LinkConn 1800.