Zabbix Database Verison not matching

[ked]

I installed Zabbix freshly on a Ubuntu 20.04 and there were some errors with packages initially but i was able to fix these and install the packages normally with other articles in the forum. Now i tried to install Zabbix on the Web Interface but there is an error that says: "The Zabbix database version does not match current requirements. Your database version: 6000000. Required version: 6040000. Please contact your system administrator." after trying to connect to the database. I already tried the steps in this post and here are the outputs of some of the commands:


mysql> show grants for zabbix@localhost;
+------------------------------------------------------------------+
| Grants for zabbix@localhost |
+------------------------------------------------------------------+
| GRANT SUPER ON *.* TO `zabbix`@`localhost` |
| GRANT ALL PRIVILEGES ON `Zabbix`.* TO `zabbix`@`localhost` |
| GRANT ALL PRIVILEGES ON `Zabbixzabbix`.* TO `zabbix`@`localhost` |
| GRANT ALL PRIVILEGES ON `zabbix`.* TO `zabbix`@`localhost` |
| GRANT ALL PRIVILEGES ON `zabbix`.`db` TO `zabbix`@`localhost` |
+------------------------------------------------------------------+


mysql> SELECT Host,User,Super_priv FROM mysql.user;
+-----------+------------------+------------+
| Host | User | Super_priv |
+-----------+------------------+------------+
| localhost | debian-sys-maint | Y |
| localhost | mysql.infoschema | N |
| localhost | mysql.session | Y |
| localhost | mysql.sys | N |
| localhost | root | Y |
| localhost | zabbix | Y |
+-----------+------------------+------------+

this is the zabbix_server.log which is constantly repeating these entries.

tail -f /var/log/zabbix/zabbix_server.log
1404:20240404:075919.822 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)
1404:20240404:075919.822 database is down: reconnecting in 10 seconds


apt list --installed | grep zabbix

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

zabbix-agent/zabbix,now 1:6.4.13-1+ubuntu20.04 amd64 [installed]
zabbix-apache-conf/zabbix,now 1:6.4.13-1+ubuntu20.04 all [installed]
zabbix-frontend-php/zabbix,now 1:6.4.13-1+ubuntu20.04 all [installed]
zabbix-release/zabbix,now 1:6.4-1+ubuntu20.04 all [installed]
zabbix-server-mysql/zabbix,now 1:6.4.13-1+ubuntu20.04 amd64 [installed]
zabbix-sql-scripts/zabbix,now 1:6.4.13-1+ubuntu20.04 all [installed]

[cyber]

Your DB is for v6, your installation is v6.4.13. Your server cannot connect to DB (no password provided (using password: NO)) to do upgrade and your frontend complains about mismatch of versions...
Verify that you have set password in server.conf... Maybe after that it manages to connect and do the upgrade... Or you can also reinstall DB, using schema from 6.4...