Zabbix 4.0.1 with MySQL 8.0.13 database

[mellis]

I am working on building a HA Zabbix setup, We decided to use MySQL 8.0.13 cluster. I was able to get the Cluster database up and going create the zabbix user and database. From the bash shell I can login to the database and show the databases and tables. Now when trying to get the zabbix server to start up the process will not login to the system.

31801:20181120:133858.571 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
31801:20181120:133858.571 database is down: reconnecting in 10 seconds
31801:20181120:133908.572 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
31801:20181120:133908.572 database is down: reconnecting in 10 seconds
31801:20181120:133918.573 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
31801:20181120:133918.573 database is down: reconnecting in 10 seconds
31801:20181120:133928.574 [Z3001] connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)
31801:20181120:133928.574 database is down: reconnecting in 10 seconds

I have also tried to create a simple php page to check the ability to login to the database and get the same error.

I guess I am wondering how to have the MySQL allow clear text passwords to login.

Thanks

[kloczek]

Message is clear "access denied", so it has nothing to do with zabbix per se or used MySQL version
Just try to login to DB using mysql client to test the issue