While working on a different task I found this user present on s4:
GRANT USAGE ON *.* TO `kraken`@`10.64.%` IDENTIFIED BY PASSWORD '*x' GRANT SELECT ON `%wik%`.* TO `kraken`@`10.64.%`
It is only present on s4.
I don't know where it comes from, I haven't found it on code, gerrit or phab.
However it is on the private repo under modules/passwords/manifests/init.pp as sqoop_mysql_user
That user has never had an active connection on s4.
./section s4 | while read host port; do echo "$host:$port"; mysql.py -h$host:$port -e "select * from sys.user_summary where user like 'kraken'";done labsdb1012.eqiad.wmnet:3306 labsdb1011.eqiad.wmnet:3306 labsdb1010.eqiad.wmnet:3306 labsdb1009.eqiad.wmnet:3306 dbstore1004.eqiad.wmnet:3314 db2140.codfw.wmnet:3306 db2139.codfw.wmnet:3314 db2138.codfw.wmnet:3314 db2137.codfw.wmnet:3314 ERROR 1146 (42S02) at line 1: Table 'sys.user_summary' doesn't exist db2136.codfw.wmnet:3306 db2119.codfw.wmnet:3306 db2110.codfw.wmnet:3306 db2106.codfw.wmnet:3306 db2099.codfw.wmnet:3314 db2095.codfw.wmnet:3314 db2090.codfw.wmnet:3306 db2073.codfw.wmnet:3306 db1150.eqiad.wmnet:3314 db1149.eqiad.wmnet:3306 db1148.eqiad.wmnet:3306 db1147.eqiad.wmnet:3306 db1146.eqiad.wmnet:3314 db1145.eqiad.wmnet:3314 db1144.eqiad.wmnet:3314 db1143.eqiad.wmnet:3306 db1142.eqiad.wmnet:3306 db1141.eqiad.wmnet:3306 db1138.eqiad.wmnet:3306 db1125.eqiad.wmnet:3314 db1121.eqiad.wmnet:3306 db1081.eqiad.wmnet:3306 clouddb1019.eqiad.wmnet:3314 clouddb1015.eqiad.wmnet:3314
Is it really needed or can we clean it up?