Installing MySQL 5.6

Installing MySQL 5.6

  • Before updating MySQL 5.1 to 5.6 you must first take a full backup of the database in MySQL Admin. 
  • MySQL Server 5.1, MySQL WorkBench and MySql Connector must be uninstalled before installing MySQL 5.6
  • Navigate to the FTP: ftp://ftp.myarrowpos.sharefileftp.com/Tech%20Stuff/Applications/MySql/New%20MySQL/
    (new ftp) ftp://ftp.myarrowpos.com/Tech%20Stuff/Applications/MySql/New%20MySQL/
  • Download the entire Dependencies folder, MySQL 5.1 essentials and GUI, and the mysql-installer-web-community-5.6.45.0. 
  • Run the Mysql 5.6.45.0 installer
  • Select Server only and hit Next
  • Hit the Execute button. 
  • Once it completes hit Next, and then next again to enter Product Configuration, enter the settings below:
  • Use the default Arrow root password then hit Next. 
  • Leave the default settings or Windows Service and hit Next.
  • Hit Execute to apply the configuration. 
  • Once complete you can hit Next and Finish. 
  • If MySQL tools are not installed you will have to install them. Run the mysqlguitools-5.0 installer. 
  • Hit Next, accept the terms in the license agreement, and install to the default older path. Select a complete install.
  • Now we need to install two packages in the Dependencies folder: ArrowMySQLConnNet_6_9_4 and mysql-connector-odbc-5.3.12. Select the typical install for both of these.
  • Verify that Microsoft.Net 4.6 or later is installed in Control Panel>Programs and Features. If it is not installed use the OfflineNDP472-KB4054530-x86-x64-AllOS-ENU file in the dependencies folder to install it. 
  • Load MySQL Admin with the root account. Restore the backup that was created earlier. 
  • After the restore completes go into User Administration to add the ArrowUser account.  Be sure to set the standard password for this account. 
  • ArrowUser needs all privileges assigned for every Schema.  Once those are all set hit Apply changes. 
  • The installation is complete, run post install to connect arrow to the right database.


    • Related Articles

    • MySQL Dump Error

      We use MySQL Dump to do backups This error is telling you that it can’t copy the mysqldump.exe file from mysqlRootFolder\bin to c:\Program Files\ArrowPOS folder. When ArrowPos starts up it looks at what version of ArrowPos that ArrowServer is running ...

    • Time Issue - Time in arrow jumps around

      Verify that the windows time settings are correct; Right time zone, set to synch automatically, etc.  Verify the address in the POS matches what google has, if it does not match update the address then go to global>store info>geo code>automatic ...

    • Windows 7 End of Life

      We do not use Win 7 home, pro, or the like.  Some systems are using specific variant of Win 10.  Our older systems use/used POSReady 7 which is a variant designed for POS guys like us.  There is an EOL, but that is October 2021.  Even then, MSFT has ...

    • ZeroTier Port Error - Windows 7

      How To Fix The ZeroTier PORT-ERROR It’s usually because of the ZeroTier network interface hasn’t installed correctly. This means we will need to do this manually. First completely close down ZeroTier One, by right-clicking on its icon in the tasktray ...

    • How to Create a Backup

      Exit ArrowPos to the desktop Click on start > Programs > MySQL >MySQL  Administrator  If you are on the Server  Server Host to localhost Username to root. If you are not on the Server Server Host to ArrowServer  Username to ArrowUser Click on Backup ...