1)Create tbl_alarm_img table
2)Grant Mysql remote access on infinite box PC
3)Create ODBC on machine PC


Create tbl_alarm_img table:
1)Run tbl_alarm_img.sql script


Create ODBC:
1)Run mysql odbc connector setup mysql-connector-odbc-3.51.30-win32.msi
2)Control Panel -> Administrative Tools -> Data Source (ODBC)
3)Click Add, select Mysql ODBC driver, click finish
4)Key in infinite as Data Source Name and complete the configuration
5)Test result will show Connection Successful if configured correctly


Grant Mysql remote access:
1)Navicat -> Tools -> Consoles..
2)Paste the following command(change the ip) onto console panel and press enter

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%'
    IDENTIFIED BY PASSWORD '*73A62A3E380B9C2D0E52067F1A84567D5D68921C'  
    WITH GRANT OPTION;
FLUSH PRIVILEGES;

