0

I tried to install zabbix on my raspberry pie with this tutorial but I am stuck a installing the default tables. Half way in it says that I should run this command:

$ zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -u zabbix -p

I get asked for a password but after that I get this:

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

What did I miss here?

Edit: the command zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz alone does work and prints a bunch of SQL commands. But why doesnt it work with both?

sirzento
  • 103

1 Answers1

0

You'll have to specify which database to create the tables on:

 zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -u zabbix -p zabbix

This assumes that the database name is zabbix, as listed in the tutorial.

vidarlo
  • 23,497