Hello,
I want to add mysql service to pmm2 with custom user, but can’t do that
pmm-admin add mysql --query-source=slowlog --username=pmm --password=password
Connection check failed: this user requires clear text authentication. If you still want to use it, please add 'allowCleartextPasswords=1' to your DSN.
mysql version: mysql Ver 14.14 Distrib 5.7.30-33, for debian-linux-gnu (x86_64) using 7.0
ldap plugins: auth_pam.so, auth_pam_compat.so, pam_user_map.so
pmm-admin --version
ProjectName: pmm-admin
Version: 2.12.0
PMMVersion: 2.12.0
Timestamp: 2020-12-01 11:57:04 (UTC)
FullCommit: e81fe912b1029095f310945f831abc71c824e139
mysql> select user, host, authentication_string, plugin from mysql.user where user = 'pmm';
+------+-----------+-------------------------------------------+-----------------------+
| user | host | authentication_string | plugin |
+------+-----------+-------------------------------------------+-----------------------+
| pmm | localhost | *SoMeHasH29929292939393939939393939393993 | mysql_native_password |
+------+-----------+-------------------------------------------+-----------------------+
1 row in set (0.00 sec)