An EASA installation is designed to 'work-off-the-shelf'.

Default passwords other than for demo are initially assigned and will need to be changed in:

1. MySQL
2. Three EASA configuration files
3. The demo password is set via the EASA configuration record for StockData

Determine strong passwords for each MySQL user: sa, demo, exceluser.

Update MySQL with the new passwords. In a mysql client:

• mysql> SET PASSWORD FOR 'sa'@'localhost' = 'new_password_for_sa';
• mysql> SET PASSWORD FOR 'demo'@'localhost' = 'new_password_for_demo';
• mysql> SET PASSWORD FOR 'exceluser'@'localhost' = 'new_password_for_exceluser';

• In each of the files below:
  • <SERVERDATA>\easa-share\admin\config\
    • excel.cfg.xml
    • excelTesting.cfg.xml
  • Find:
    • <property name=“hibernate.connection.username”>exceluser</property>
  • Update the corresponding password property below it with a new password:
    • <property name=“hibernate.connection.password”>new_password_for_exceluser</property>

• In the file below:
  • <SERVERDATA>\easa\admin\config\easa.cfg.xml
  • Find:
    • <property name=“hibernate.connection.username”>sa</property>
  • Update the corresponding password property below it with a new password:
    • <property name=“hibernate.connection.password”>new_password_for_sa</property>

• Navigate to EASA→Administrator→Configure→Databases→Configure Databases
• Select StockData
• Click Edit
• Update the password for demo