Zabbix のデータベースをきれいさっぱり初期化して再インストールした

emerge mysql

emerge --config =dev-db/mysql-8.0.19-r1

mysqld --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-federated --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --initialize-insecure --init-file=/var/tmp/portage/dev-db/mysql-8.0.19-r1/temp/tz.sql --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp/ --user=mysql

mysql> alter user 'root'@'localhost' identified by 'hogehoge';

mysql> create database zabbix;
Query OK, 0 rows affected (0.00 sec)

mysql> create user zabbix@localhost identified by 'hogehoge';
Query OK, 0 rows affected (0.02 sec)

mysql> grant all on zabbix.* to zabbix@localhost;
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

$ mysql -u zabbix -p zabbix < /usr/share/zabbix/database/mysql/schema.sql 
Enter password: 
$ mysql -u zabbix -p zabbix < /usr/share/zabbix/database/mysql/images.sql 
Enter password: 
$ mysql -u zabbix -p zabbix < /usr/share/zabbix/database/mysql/data.sql 
Enter password:

D### Option: DBHost
#       Database host name.
#       If set to localhost, socket is used for MySQL.
#       If set to empty string, socket is used for PostgreSQL.
#
# Mandatory: no
# Default:
# DBHost=localhost

DBHost=localhost

### Option: DBName
#       Database name.
#       For SQLite3 path to database file must be provided. DBUser and DBPassword are ignored.
#
# Mandatory: yes
# Default:
# DBName=

DBName=zabbix

### Option: DBSchema
#       Schema name. Used for IBM DB2 and PostgreSQL.
#
# Mandatory: no
# Default:
# DBSchema=

### Option: DBUser
#       Database user. Ignored for SQLite.
#
# Mandatory: no
# Default:
# DBUser=

DBUser=zabbix

### Option: DBPassword
#       Database password. Ignored for SQLite.
#       Comment this line if no password is used.
#
# Mandatory: no
# Default:
# DBPassword=

DBPassword=hogehoge

/etc/init.d/zabbix-server start

$DB['DATABASE'] = 'zabbix';
$DB['USER']     = 'zabbix';
$DB['PASSWORD'] = 'hogehoge';