Re: sha256_password deprecated warnings filling logs

[仁刚 谭]

users in the DB:
[(none)][Tue Jul 21 08:48:44 2020]->select user,host,plugin from mysql.user;
+----------------------------+-----------+-----------------------+
| user | host | plugin |
+----------------------------+-----------+-----------------------+
| icadmin | % | caching_sha2_password |
| mysql_innodb_cluster_11 | % | caching_sha2_password |
| mysql_innodb_cluster_12 | % | caching_sha2_password |
| mysql_innodb_cluster_13 | % | caching_sha2_password |
| mysql_router1_3p7bp1mv3082 | % | caching_sha2_password |
| mysql_router2_5v235odtjied | % | caching_sha2_password |
| mysql_router3_2raquqjhkdki | % | caching_sha2_password |
| mysql_router3_4xbkqdqxzorx | % | caching_sha2_password |
| mysql_router3_feebfmjr38y7 | % | caching_sha2_password |
| mysql_router3_g0wejw69xhjq | % | caching_sha2_password |
| mysql_router3_iqtduvv4vd86 | % | caching_sha2_password |
| mysql_router3_lrbx88opfjmu | % | caching_sha2_password |
| mysql_router3_sc6x8sgk66mx | % | caching_sha2_password |
| mysql_router3_tlonvb2usxre | % | caching_sha2_password |
| mysql_router4_o6t0kfh9zd0c | % | caching_sha2_password |
| mysqltest | % | caching_sha2_password |
| repl | % | caching_sha2_password |
| root | % | caching_sha2_password |
| bkuser | localhost | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | caching_sha2_password |
| mysql.sys | localhost | caching_sha2_password |
| root | localhost | caching_sha2_password |
+----------------------------+-----------+-----------------------+