Unable to determine current Zabbix database version: the table "dbversion" was not found
Here's how to do each step:
Create the zabbix mysql user account
use the mysql
shell and execute this command:
mysql> create user zabbix@localhost identified by 'YourSecurePassword';
Query OK, 0 rows affected (0.00 sec)
Grant all necessary privileges for the zabbix mysql user account.
use the mysql
shell and execute this command then quit:
mysql> grant all privileges on zabbix.* to zabbix@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Unzip and run the server.sql.gz file to finish the configuration settings on the zabbix database
This one is easy. You'll need to wait a few minutes until this finishes. Also, you will be using the password for the zabbix user you set up during the first step:
zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
Enter password:
Update/setup the Admin user account password
Again, you'll need a bycript-encrypted password. I got mine from here:
After that, you can enter the mysql shell and run this command and quit the shell:
mysql> update zabbix.users set passwd=('$2a$12$wdflkjsdflksdjflskdfji......') where userid='1';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> quit;
Bye
Give it a few seconds and after that, you can login to your Zabbix server using the default 'Admin' username and the (unencrypted) password you setup from the previous step by visiting your Linode's IPv4 address on your browser.
I've completed this process now a few times and it seems relatively easier than the previous one though it is more or less the same. Hope this info makes things easier for anybody else until this gets fixed :-)
标签:quit,shell,dbversion,zabbix,报错,user,mysql,password,was From: https://www.cnblogs.com/tiger9637/p/17206754.html