Zabbix 3.2 Web -> Cant login with Admin as user & zabbix as password

[Jesh]

I have installed Zabbix 3.2 on Linux ubuntu machine. I have also installed mysql and completed creating the database(db name as zabbix) by using script.sql .

And also I changed the DBName as zabbix & provided the correct DBHost, DBpassword, DBUser, DBPort in zabbix_server.conf file and restarted zabbix-server, mysql, apache2 services.


But When I tried to login in web using username as Admin/admin/Zabbix/root password as zabbix, I am getting Login name or password is incorrect. and Account is blocked for 30 seconds error.

I also checked that zabbix-server is connected to this zabbix database. And the password is md5 encrypted value of zabbix.

I am yet to log in for the first time into my zabbix web. Can you please suggest solutions ?

[Atsushi]

I have not heard of script.sql.
Please tell us more specifically what kind of operation did you do when creating the database.

If you installed Zabbix as a package, it should have been the following procedure.

$ mysql -uroot -p
Enter password:
mysql> create database zabbix character set utf8 collate utf8_bin;
mysql> grant all privileges on zabbix.* to zabbix@localhost identified by 'password' ;
mysql> exit
$ zcat /usr/share/doc/zabbix-server-mysql/create.sql.gz | mysql -uroot zabbix -p
Enter password:
$

If you installed from the source, you need to load the following three SQL files.
schema.sql
images.sql
data.sql

https://www.zabbix.com/documentation/3.2/manual/appendix/install/db_scripts

[allexpetrov]

Hi,

The default password is zabbix and the username is Admin. Make sure that you've using the correct credentials.

In any case - you can change the password directly in SQL by issuing:

update zabbix.users set passwd=md5('zabbix') where alias='Admin';

Atsushi, I think he was installing from packages and imported schema create.sql.gz

Regards,
Alex!

[elonga]

Hey, I have a problem! When I try to believe new users on zabbix, they cannot enter zabbix, they do not login or recognize a password, I have weeks on this and I am desperate! help please help!