Page History

By default, there are two MySQL users:

• root
• kiuwan (defined by KIUWAN_MYSQL_USER property at settings.custom file)

In case you need to change the password for MySQL root, please follow these steps:

1. Log-in to KOP container with root user
2. Connect to mysql shell by executing:
   • mysql -uroot -p mysql ( password as defined by MYSQL_ROOT_PWD property at settings.custom file)
3. Within mysql shell execute following commands

   1. UPDATE user SET Password=PASSWORD('new_password') WHERE USER='root';

   2. FLUSH PRIVILEGES;

In case you need to change the password for MySQL kiuwan, please follow these steps:

1. Log-in to KOP container with root user
2. Connect to mysql shell by executing:
   • mysql -uroot -p mysql ( password as defined by MYSQL_ROOT_PWD property at settings.custom file)
3. Within mysql shell execute following commands

   • UPDATE user SET Password=PASSWORD('new_password') WHERE USER='kiuwan'; ( user as defined by KIUWAN_MYSQL_USER property at settings.custom file)

   • FLUSH PRIVILEGES;

   • exit;
4. Change to directory of the container where KOP is installed (KIUWAN_VOL property at settings.custom file)
5. Execute next commands (substituting old_password and new_password with your proper values) :

   • sed -i 's|password=old_password|password=new_password'|g' deployconfig/kiuwan/configuration/WEB-INF/classes/config/hibernate/csaas-hibernate.properties

   • sed -i 's|^KIUWAN_MYSQL_PWD=.*|KIUWAN_MYSQL_PWD=new_password'|g' koptools/deployKiuwan.sh

   • sed -i 's|password=old_password|password=new_password'|g' release/installation/conf/db-connection.properties

   • ONLY if you are using HTTPS :

     • sed -i 's|password=old_password|password=new_password'|g' deployconfig/kiuwan/configuration/WEB-INF/classes/config/application.properties.http.rollback

     • sed -i 's|^KIUWAN_MYSQL_PWD=.*|KIUWAN_MYSQL_PWD=new_password'|g' koptools/deployKiuwan.sh.http.rollback

6. Change to koptools
7. Execute next script :
   • ./redeployKiuwan.sh