首页 > 其他分享 >zabbix 安装报错 the table "dbversion" was not found

zabbix 安装报错 the table "dbversion" was not found

时间:2023-03-11 19:35:46浏览次数:55  
标签:quit shell dbversion zabbix 报错 user mysql password was

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

相关文章