Talend Infobright Connector Problem

Problem
Exception in component tInfobrightOutput
java.sql.SQLException: Access denied for user ‘test’@‘192.168.3.2’ (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2938)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1601)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1710)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2430)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:2359)
    at com.mysql.jdbc.Statement.execute(Statement.java:719)
    at com.infobright.io.InfobrightNamedPipeLoader$ExecutionThread.run(InfobrightNamedPipeLoader.java:207)


while running the script, table is created in Target database and unable to insert data then throws the above exception.
for this i am placing target table as mysql [in same infobright databse] insted of tInfobrightOutput[infobright loader] the script is executed successfully.


Solution
Here is the explanation. The connector needs the “file” privilege because it is doing a LOAD command from a named pipe (FIFO). The standard MySQL output component uses INSERT statements instead, so it doesn’t need this privilege.


“the FILE privileges are global and cannot be applied to a single database”
So correct SQL Statement is:
GRANT FILE ON *.* to test@localhost;


use This url for downloading talend infobright Connector
http://www.infobright.org/Downloads/Contributed-Software/