In cmso-optimizer root account is used to not only initiate the database but also use it later one (DB_USERNAME & DB_PASSWORD env variables)

That's a bad security practice and you should fix it by using root account only to create the database and dedicated user account and then use only that user account