Additional info
Now using zabbix 6.2.2 I noticed that /usr/share/doc/zabbix-server-mysql/create.sql.gz no longer exists. After some googling I found zabbix-sql-scripts. Unsure what to import from the new folder /usr/share/doc/zabbix-sql-scripts I picked ./mysql/server.sql.gz because we use MariaDB.
This indeed set up the database zabbix.users.
Actual question
However: In the old zabbix version we ran update users set passwd=md5('PASSWORD') where alias='Admin' on zabbix.users. Alias doesn't exist anymore so I switched to update users set passwd=md5('PASSWORD') where username='Admin'. That seemed to do the trick, but didn't. While the command runs without error, the password is not correctly set.
Even though I set login_user: Admin and login_password: PASSWORD ansible fails to connect. This does not happen if the password is not set and standard "zabbix" is used.
Why is setting the password no longer working?
I am still very new to zabbix, but the project worked before on an older zabbix version just importing aforementioned create.sql.gz.