SysEvtCol.exe cannot start while mysql password changed.

SysEvtCol.exe cannot start while mysql password changed.

 Since I m the first time using ELA, I have try this problem couple of days...


The situation is I must change the Mysql password from default blank to something


so I am using the following methods to change the password


Connect to EventLog Analyzer's MySQL. Go to <EventLog Analyzer Home>/mysql directory, execute the following command 

./bin/mysql -u root- h localhost-- port=33335 -D EVENTLOG

Execute the following queries in the database

USE mysql


update user set password=password ('New Password') where user = 'root';


FLUSH PRIVILEGES;


Stop EventLog Analyzer.

Go to <EventLog Analyzer Home>/data directory, edit dbparam.conf

File and change the password to the 'New' password.

Restart EventLog Analyzer.



And then I goto modify password in Eventlog\server\default\deploy\mysql-ds.xml 

<password /> to <password>something</password>


then Restart the Eventlog Analyzer Services..


ok, 8400 come out and we can access the web clients, but sysEvtCol.exe with UDP port 513 514 does not come out.


I have try to use command prompt with command 

bin\SysEvtCol.exe -loglevel 2 -port 513 514 null -fwport 5000 5001 

it show me that Error open DB Connection 2


I don't know why, but I just want to have a correct procedure for changing the mysql's password.


Thanks for your attention and appreciate for your idea.




                New to ADSelfService Plus?