gistfile1.txt

[root@icinga2 icinga2]# cat /etc/icingaweb2/resources.ini

[icingaweb_db]
type = db
db = "mysql"
host = "10.20.1.60"
port = "3306"
dbname = "icinga2_web"
username = "icinga2_web"
password = "password"

[icinga_ido]
type = db
db = "mysql"
host = "10.20.1.60"
port = "3306"
dbname = "icinga2_data"
username = "icinga2"
password = "password"

[ldap]
type = ldap
hostname = "localhost"
port = "389"
root_dn = "dc=example,dc=com"
bind_dn = "[email protected]"
bind_pw = "abc123"
[root@icinga2 icinga2]# mysql -uicinga2 -ppassword -D icinga2_data -h10.20.1.60
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 5217
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [icinga2_data]> Bye
[root@icinga2 icinga2]# mysql -uicinga2_web -ppassword -D icinga2_web -h10.20.1.60
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 5221
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

gistfile2.txt

[2017-01-24 08:02:40 +0000] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!
[2017-01-24 08:02:50 +0000] critical/IdoMysqlConnection: Connection to database 'icinga2_data' with user 'icinga2' on '10.20.1.60:3306' failed: "Access denied for user 'icinga2'@'10.20.1.20' (using password: YES)"
Context:
	(0) Reconnecting to MySQL IDO database 'ido-mysql'

[2017-01-24 08:02:50 +0000] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!
[2017-01-24 08:03:00 +0000] critical/IdoMysqlConnection: Connection to database 'icinga2_data' with user 'icinga2' on '10.20.1.60:3306' failed: "Access denied for user 'icinga2'@'10.20.1.20' (using password: YES)"
Context:
	(0) Reconnecting to MySQL IDO database 'ido-mysql'

[2017-01-24 08:03:00 +0000] critical/IdoMysqlConnection: Exception during database operation: Verify that your database is operational!

gistfile3.txt

[root@icinga2 icinga2]# mysql -uicinga2 -ppassword -D icinga2_data -h10.20.1.60
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 5263
Server version: 5.6.34-79.1-log Percona Server (GPL), Release 79.1, Revision 1c589f9

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [icinga2_data]> show grants;
+-----------------------------------------------------------------------------+
| Grants for [email protected].%                                                |
+-----------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'icinga2'@'10.20.1.%' IDENTIFIED BY PASSWORD <secret> |
| GRANT ALL PRIVILEGES ON `icinga2_data`.* TO 'icinga2'@'10.20.1.%'           |
+-----------------------------------------------------------------------------+
2 rows in set (0.04 sec)