Zabbix new installation missing MySQL password

[tstav]

I am using the installation instructions for Zabbix 6.2 with Ubuntu 22.04 (Server, Frontend, Agent, MySQL,Apache)
While installing "apt install zabbix-server-mysql zabbix-frontend-php zabbix-apache-conf zabbix-sql-scripts zabbix-agent", I was not prompted to type a MySQL password (in multiple installation tries)
So when I had to call MySQL with mysql -uroot -p, I did not have a password to type.
Can anyone help?

[tstav]

Actually, there is something missing or not adequately clarified from the installation procedure
Step three (c) says "Create initial Database and make sure you have database server up and running" but the actual commands to install MySQL server are missing,
This is kind of misleading since one might interpret (actually me) that installing in the second step the zabbix-server-mysql, is in fact installing MySQL server.
Well, no. We have to install the server ourselves with "apt install mysql-server -y"
Cheers.

[tim.mooney]

Actually, there is something missing or not adequately clarified from the installation procedure
Step three (c) says "Create initial Database and make sure you have database server up and running" but the actual commands to install MySQL server are missing,

That section of the instructions could indeed be more explicit, by repeating information that's present elsewhere in the documentation. The full documentation does explain that you have to have a database created somewhere. If you think about that, and read the full documentation, you'll understand that not all sites are going to have the database server running on the same host as the Zabbix server. For your deployment, you want MySQL or MariaDB or Percona running on the same system where Zabbix server is running, but not all sites want that.

Since not all sites want the "everything on one system" install, the packages that install Zabbix server with support for MySQL can't assume that the full database server should also be installed on the same system.

So make sure you have database server software installed on the system you want it to run on, and make sure it's running, the zabbix database has been created with correct parameters, there's a dedicated database user that can connect (and any firewall(s) involved allow the connection), and that you can use the "mysql" command from the system that will run zabbix_server to connect to the database as the database user.