How to install the database for Zed Axis Automate

Follow these steps to download and install the database software for Zed Axis Edi.  You will need to have this installed before you can run Zed Axis Edi.  Zed Axis uses a MySQL 5.0 for Windows database application, this is an open source application that is provided under a community licence.

Install MySQL 5.0 for Windows database: 
  1. Download the copy of MySQL 5.4 for Windows (32bit) from here or MySQL 5.1 for Windows (64bit) from here 

  2. Unzip and run the file setup.exe, select the Typical installation and click next

  3. By default the MySQL database application will install in the following folder C:\Program Files\MySQL\MySQL Server 5.0, we recommend that you use this folder. 

  4. Once the installer as at the final stage check the option to “Configure MYSQL Server now”, this will start the configuration wizard. 

  5. Select the Standard Configuration and click Next 

  6. Check the option to Install as Windows Service & set the service name as MYSQL in the drop down list and click Next

  7. Check the option to Modify Security Settings and make your password: root (you will need to enter this when you start Axis Edi for the first time) 

  8. On the final stage click on Execute it will take several minutes and the database will be installed. 




Install the MySQL database connector

  1. Run the file called "mysql-connector-odbc-3.51.27-win32.msi
  2. Select the Typical setup type and next 
  3. The installation process should then be completed. 

Set the database properties and password

  1. Once you have installed the Zed Axis application, start that from the desktop icon or the program folder 
  2. The first time that you click on the EDI tab you will need to set the database details, you will only need to do this once. 
  3. Browse to the location of the mySql.exe file, if you used the default install location you should find it here C:\Program Files\MySQL\MySQL Server 5.0 
  4. Click OK and Zed Axis will proceed to open if you get and error then please make sure you have followed all the steps above, otherwise contact Zed Systems support for more assistance 
  5. If you are prompted to check you password you may have not entered it as root, in order check that the password was set correctly use the MySQL Server Instance Config Wizard to update the password.  If you have forgotten your password you will need to uninstall MySQL and the instance setttings in order to reset the password.

Troubleshooting Errors:

Cannot create Windows service for MySql

Add Feedback