Step.(1). Create a user with root privileges
mysql > Create user ‘xyz’@’%’ identified by ‘xyz’;
mysql > Grant all on *.* to ‘xyz’@’%’ identified by ‘xyz’;
mysql > flush privileges;
Step.(2). Add exception to firewall with the port no. 5029 if firewall is on.
Step.(3). Execute infobright remote loader from the command prompt as
Java -jar infobright-core-3.4.jar
*Note – Step(3) is only needed whenever we want to load the data into infobright
mysql > Create user ‘xyz’@’%’ identified by ‘xyz’;
mysql > Grant all on *.* to ‘xyz’@’%’ identified by ‘xyz’;
mysql > flush privileges;
Step.(2). Add exception to firewall with the port no. 5029 if firewall is on.
Step.(3). Execute infobright remote loader from the command prompt as
Java -jar infobright-core-3.4.jar
*Note – Step(3) is only needed whenever we want to load the data into infobright