How to install the database for Zed Axis Automate

Overview

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


Run the Zed Axis database installer package: 

  1. Download the Zed Axis database installer from here 
  2. Run the installer file and the database files and connector will be installed.
  3. Once complete you will see a message that the MySQL database has been installed successfully.

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 Automate 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:

Error: Error Nr.1045 Access Denied for user 'root'@'localhost (using password: YES)

This error occurs because the password used to connect to the database is incorrect.  This may have occur because you are re-installing the MySQL server or previously had an installation of MySQL server on this PC.  In order to set up the password again you will need to use the MySQL Server Instance Config Wizard to update the password.  If you have forgotten the password you will need to uninstall MySQL and close any instances or MySQL before installing again.


Cannot create Windows service for MySql