ERROR 1046 (3D000) at line 1: No database selected

[colporteur]

I'm hoping someone in the community will share their experience. Three days ago I completed a successful installation of zabbix and documented my installed. When I attempted the exercise today, the error appears. I've attached a screen shot.

Error message on running sudo zcat /usr/share/zabbix/sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p

Installing Zabbix 7.4 on Raspberry Pi using instructions provided at:
https://www.zabbix.com/download?zabb...raspberry_pi_o s&os_version=13&components=server_frontend_agent &d b=mysql&ws=nginx

Bill of Materials

Hardware:

Raspberry Pi 5 8G Memory

64M SD card

Software:

64 bit Raspberry Pi OS Lite Debian version 13 (trixie) release date 18 June 2026

zabbix version 7.4

nginx 1.26.3

php version 8.4

MariaDB Server version 11.8.6

[colporteur]

My apologies. Problem solved. Filed to identify the database at the end of the command
zcat /usr/share/zabbix/sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix <---mistook it for a password