Hi,
what you have to do is the following (in this order!):
Go to the i-doit admin center and navigate to tenants. Write down the username for each tenant in the Mysql section. Change the password for each MySQL user in the admin center GUI.
Open a mysql client and change the MySQL password for the users that you just identified (matching the passwords you entered in the admin center). Don't forget to commit a 'flush privileges;' command.
Try to login to i-doit. If you can still login, go on and change the system user password.
Open the file /[idoit_webroot]/src/config.inc.php and look at the
$g_db_system = array(
…
"user" => "xxx",
"pass" => "yyy
...
part. Change the password to a new password in the file and save it.
Open a mysql client and change the MySQL password for the user mentioned in the config.inc.php file. Don't forget to commit a 'flush privileges;' command.
Login to i-doit
Additional expert hint: The tenant database passwords are set in the 'idoit_system' database in table 'isys_mandator'.
