StarCode

MySQL SERVER INSTALLATION, CONFIGURATION, AND HOW TO USE WITH STARCODE NETWORK

 

This document describes how to install MySQL server (5.7.19) on Windows PC, and how to use StarCode Network with MySQL server from other computers, or Android devices on the network. Please contact for any questions related to this guide on support@invegix.com, or you can visit the product support page http://www.invegix.com/starcode/support/

 

1.     MySQL Server  Download

2.     Installation of MySQL Server Dependencies

3.     Installation of MySQL Server

4.     Enable Remote Access on MySQL Server / Enable Access from Other Computers Running StarCode

5.     Configuration of StarCode Network

1. MySQL Server Download

 

There are several ways to install MySQL. This article focuses on utilizing MySQL Installer for Windows to install MySQL. This guide is for version 5.7.19 of MySQL. Other versions of MySQL have similar instructions. The Windows installer is 32-bit but can install both 32 bit and 64 bit binaries depending on whether your computer is x86 (32-bit) or x64 (64-bit).

 

Please visit https://dev.mysql.com/downloads/installer/, and you will see following page

 

             

 

Scroll to the bottom of the page to find one or more MSI installers. Choose the installer with larger file size. The smaller installer will use the Internet during installation to download data, while the bigger installer has everything bundled inside, and you can use it again to install on other computer if required.

 

If you can’t find this version of the MySQL installer on the link provided above, then you find it under archived installers of MySQL. The linked to archived versions of MySQL installer is following

 

https://downloads.mysql.com/archives/installer/  [Archived MySQL Installers]

 

Click Download button. You may be navigated to a screen that prompts creation of an account with Oracle. On that screen, scroll to the bottom to see a link “No thanks, just start my download”, that allows download without creating an account. Click that link to start the download. Below is the screenshot of the page that may appear.

 

 

                      

 

After download is complete, it will normally appear in your Downloads folder on Windows PC.

2. Installation of MySQL Dependencies

 

Before installing MySQL server, it is necessary to install all the dependencies required by MySQL server installer. Otherwise the installation will fail, and it will be difficult to repair uncompleted installation.

 

First you need to download following two components and run these installers. It does not matter whether your PC/Windows is 32 bit or 64 bit, MySQL installer requires both of them on your PC

 

Download VC redistribution version 2013 from the following link, and install.

http://www.invegix.com/downloads/vcredist_13_x86.exe

 

Download VC redistribution version 2015 from the following link, and install.

http://www.invegix.com/downloads/vcredist_15_x86.exe

 

If your Windows is 32 bit, then you do not need download and install following further two dependencies. If your Windows on your PC is 64 bit, then you need to download and install following two dependencies as well. Otherwise, installation will fail and MySQL will not be installed and it will be difficult to repair the installation.

 

Download VC redistribution version 2013 from the following link, and install.

http://www.invegix.com/downloads/vcredist_13_x64.exe

 

Download VC redistribution version 2015 from the following link and install.

http://www.invegix.com/downloads/vcredist_15_x64.exe

3. Installation of MySQL Server

 

Now double-click on the MySQL installer which you downloaded in the previous step. It will take a few seconds for the installer to bring End User License Agreement on the screen. Accept the agreement and you will be prompted with a selection of installation type. Choose Full as shown below.

 

 

                   Description: C:\MySQL_Installation_Screenshots\full.png

 

 

Click Next, and it will show the installation screen, as shown below. All the components will be listed. Please note that MySQL Workbench will be downloaded during installation. You can also install it separately if required.

 

                  Description: C:\MySQL_Installation_Screenshots\ready_to_install.png

 

 

Click Execute to start the installation. MySQL Workbench will be downloaded during installation, and you must be connected to Internet. You can also install it separately if Internet is not available during the installation process. On clicking Execute button, installer will show following screen

 

 

                    Description: C:\MySQL_Installation_Screenshots\downloading_work_bench.png 

 

 

Installer will update the status against each component as it installs or downloads required components. Once finished, following screen will be shown with Next button enabled and status against each component must be Complete at this stage.

 

 

                   Description: C:\MySQL_Installation_Screenshots\packages_installed_complete.png

 

 

Click Next button. Installer will show the following screen product configuration screen.

 

 

                   Description: C:\MySQL_Installation_Screenshots\prodcut_configuration.png

 

 

Click Next to proceed with further installation.

                   

Type and Networking screen will be shown. Please make sure you select “Standalone MySQL Server/Classic MySQL Replication” option is selected. 

                  

 

                    Description: C:\MySQL_Installation_Screenshots\type_and_networking.png

 

 

Click Next to proceed to next screen. Installer will show the following screen. Please select “Server Machine” against Config Type as shown in the following screen.

 

 

                Description: C:\MySQL_Installation_Screenshots\type_and_networking_2.png

 

 

No need to change anything else on this screen. Click Next to proceed to next screen.

This is Accounts and Roles screen. MySQL server has one built-in user called root. You need to set the password for root user. You will use this user to login to MySQL server from StarCode Network. Enter password as shown in the following screen.

 

 

                   Description: C:\MySQL_Installation_Screenshots\accounts_and_roles.png

 

 

Click Next to continue. Installer will show following Windows Service screen.

 

 

                  Description: C:\MySQL_Installation_Screenshots\start_as_windows_service.png

 

You do not need to change anything. This configuration will make sure that MySQL starts automatically on starting your computer. Click Next to continue.

Following Plugins and Extensions screen will be shown. Please do not change anything on this screen and click Next to continue.            

 

 

                 Description: C:\MySQL_Installation_Screenshots\plugins_extensions.png

 

 

Following Apply Configuration screen will be shown. Click the Execute button on this screen and watch the status as installer configures different components.

 

 

                  Description: C:\MySQL_Installation_Screenshots\apply_configurations.png

 

After configuration is complete, following screen will be shown by the installer.

 

 

                  Description: C:\MySQL_Installation_Screenshots\finish.png

 

 

Click Finish button on Apply Configuration screen, and this complete the server configuration step. After this step following screen will be shown.

 

 

                  Description: C:\MySQL_Installation_Screenshots\product_configuration.png

 

 

Click Next button to continue, and installer will show the following router configuration screen. You do not need to change anything on this screen.

 

                   Description: C:\MySQL_Installation_Screenshots\router_configuration.png

 

 

Click Finish button on this screen, and this will complete rounter configuration. After this step, installer will show the following screen.

 

 

                   Description: C:\MySQL_Installation_Screenshots\router_configuration_complete.png

 

 

Click Next button to continue. It will now show the Connect to Server screen. This will test whether installed server is working as expected or not. Initially the Next button on Connect to Server screen will be disabled. You need to press the Check button to test the connection to server.

 

 

If the connection to server succeeds, then Next button will become enabled. Press Next button on this screen to continue.

 

 

                   Description: C:\MySQL_Installation_Screenshots\connect_to_server.png

 

 

On pressing the Next button following Apply Configuration screen will be shown. This will update the status as the installer configures different components of the server. You need to press Execute button in order to start the configuration process.

 

 

                    Description: C:\MySQL_Installation_Screenshots\apply_configuration_final.png

 

 

On completion, following screen will be shown. Press Finish to continue.

 

 

                   Description: C:\MySQL_Installation_Screenshots\apply_configuration_final_finish.png

 

 

 

After this step following product configuration screen will be shown. All the installed products with status will be listed on this screen.

 

 

 

                   Description: C:\MySQL_Installation_Screenshots\prodcut_configuration_3.png

 

 

Click Next to continue and proceed to final step.

 

                 Description: C:\MySQL_Installation_Screenshots\final_finish.png

 

Press Finish button to complete the MySQL server installation.

 

At this point, MySQL Server has been installed and it is running. To access MySQL Server, we will use MySQL Workbench as a client. Launch MySQL Workbench from Windows start menu. When Workbench starts, a connection to local database would have been created by default like so. If not then create a new MySQL connection by clicking on + button, and you will see the following screen.

 

 

Description: C:\Lab\mysql_installation_manual\New folder\23.png

 

Enter above parameters and click on Test Connection. If everything is correct, it will report success. Click OK to save this connection.

 

Double-click on Local instance MySQL Server 5.7 connection and enter root password to gain access to the server.

 

You can use MySQL workbench for various tasks such as importing and exporting data, user management, database management and many more functions available in this application.

 

This concludes the installation and configuration of MySQL server required for StarCode Network or StarCode Network Plus.

 

4. Enable Remote Access on MySQL Server / Enable Access from Other Computers Running StarCode

 

MySQL does not allow connections from other computers on the network by default. You will have to enable this function manually. The procedure is described below.

 

Step 1: Launch CMD prompt of Windows. You can start this program from Run menu of Windows Start menu by typing CMD.exe

 

Step 2: Go to bin folder of MySQL server installation from the command prompt where you have installed the server. Normally it would be in C:\Program Files\MySQL\MySQL Server 5.7\bin. So you would have to type following command on command prompt

 

cd C:\Program Files\MySQL\MySQL Server 5.7\bin

Please adjust the path according to your local installation.

 

STEP 3: Now type the following command and press ENTER. Do not forget to replace [password] with the password of root user that you created earlier.

 

mysql –uroot –p[password]

 

For example, if you set a root user password as Mypass123, then you will type following command and press ENTER

 

mysql –uroot –pMypass123

 

 

STEP 4: Now you will be on mysql command prompt. In order to enable remote access, you would have to run following two commands. Please do not forget to replace [password] with the password of your root user. Replace user root with some other user name, if you want to enable remote access for some other user. Type first command then press ENTER. This command should execute successfully.

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '[password]';

 

After it has been executed successfully, you would have to run the second command. Type following line command prompt and press ENTER.

 

FLUSH PRIVILEGES;

 

This procedure completes enabling the remote access to MySQL server from other devices or computers on the network. Now you would be able to network different computer running StarCode Network.

 

Please note that you might have to repeat the above procedure after creating the inventory and sales databases if StarCode Network does not connect successfully to MySQL server.

5. Configuration of StarCode Network

 

After successful installation of MySQL server and configuration, the next step is to configure StarCode Network to make use of this server. Start StarCode Network/Plus. If it is the first time then it would not be able to connect to the server. Now launch MySQL Server Settings dialog from Tools menu. If you are running StarCode Network on the same computer where MySQL server is installed, then following configuration will be fine.

 

 

                       

 

 

Username is “root”, which we created during configuration of MySQL server. Enter password, server address and port number. Click on Test, if the connection is successful, a success message will be dispalyed. Click Save, and your configuration will be saved.

 

If you are running StarCode on some other computer on your network, or even on some Android tablet and want to connect to this server via Wifi or LAN, please follow following steps.

 

From Windows Start menu, in the search box typ cmd.exe, and launch CMD.EXE. In this command window type ipconfig and hit ENTER. You will see something similar to following screen.

 

              Description: C:\Lab\mysql_installation_manual\New folder\27.png

 

The purpose is to know the IP address of computer where the MySQL server is installed. As shown above ipconfig command will show the IPv4 address of this computer. In this case the IP address is 192.168.1.7 and your IP would be different from this.

 

Now launch MySQL Server Settings dialog from StarCode Network Tools menu, and fill in following parameters. You will need to provide the IP address of server computer.

 

   

                  

 

 

Test the connection parameters, if successful then click Save. Please note that if the IP address of your computer (server) where MySQL server is installed changes (because of any reason), you would need to change settings on this dialog as well.

 

You can also use the computer name in place of IP address. Infact, this is recommended to use computer name rather IP address of the server. IP address would normally change on rebooting the computer, but the computer or server name will not change.

Once you are able to connect to MySQL server from StarCode, the next step is to create inventory and sales databases. Click on Databases icon on the home screen. Following dialog will be displayed.

 

 

                             Description: C:\Lab\mysql_installation_manual\New folder\29.png

 

 

Click on Create New Inventory Database. Enter some name for your inventory database and click OK. Similarly for Sales database, create new sales database. Appropriate messages will be displayed on success or any errors.

 

This completes the configuration of StarCode Network, and now you are ready to poplulate your inventory, or import from Excel file and start selling products.

 

If you have any further questions, and require further support, please write to support@invegix.com