Zabbix 5.2 on Ubuntu 20.04 (MySQL Install)

[stevefxp]

Hello all,

I am new to Zabbix and testing on my home virt lab. I have done the install portion but cannot seem to get past the MySQL portion. First off is there a MySQL root password assigned by default? If yes what is it. If no then I have tried to login as root without a password and it does not let me. For those that have a MySQL implementation how did you get past the MySQL install pieces?

Thanks,
Steve

[NilsA]

Hey Steve,

I'm using mariadb - but it shouldn't be too different for your system. There's no default password for admin - you have to set it.
After installing your mariadb / mysqldb simply use "mysql_secure_installation". The script will ask for root password, just press enter, then set a new one and answer "y" to everything else.
Then continue setting up your db as required (see official documentation).

Hope I could be of help.

[stevefxp]

Hello NilsA ,

Thanks for your reply. The strange issue I am running into is after I install zabbix-server-mysql I cannot run mysql_secure_installation. It does not see this as a proper command. I have even rebooted my vm but still no go. If I install the standard mysql-server then it works fine. Did you run into this?

Thanks,
Steve

[Atsushi]

Even if you install zabbix-server-mysql, DBMS is not installed at the same time. If you want to start the MySQL server on the same server, please install mysql-server.

[stevefxp]

Even if you install zabbix-server-mysql, DBMS is not installed at the same time. If you want to start the MySQL server on the same server, please install mysql-server.

Ahhh...so just add mysql-server and mysql-client to zabbix-server-mysql install process?

[Atsushi]

If you are using the apt command, you should install mysql-server.

[stevefxp]

What does zabbix-server-mysql do for me then? It does not install MySQL?

[Atsushi]

A package called zabbix-server-mysql contains programs and their settings that use a MySQL server as a data store. The database server for the data store can use a server in a different chassis or RDS on AWS without installing it on the same server, so you can select it according to your environment. If you want to run the MySQL server on the same server, please install mysql-server separately.

[stevefxp]

A package called zabbix-server-mysql contains programs and their settings that use a MySQL server as a data store. The database server for the data store can use a server in a different chassis or RDS on AWS without installing it on the same server, so you can select it according to your environment. If you want to run the MySQL server on the same server, please install mysql-server separately.

Thanks for the clarification. I really wish Zabbix would update their install instructions, so it saves us newbies alot of time trying to figure out what is going on.