Re: sha256_password deprecated warnings filling logs

[Admin Admin]

mysql> INSTALL PLUGIN CONNECTION_CONTROL SONAME 'connection_control.so';
Query OK, 0 rows affected (0.15 sec)

mysql> INSTALL PLUGIN CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS SONAME 'connection_control.so';
Query OK, 0 rows affected (0.04 sec)

1.first ,install the connection_control plugins ,make sure it's enabled

2.select the information_schema.connection_control_failed_login_attempts table to find out which client attemps to connect the mysql cause the errors filling mysql errorlog,you can see the “ FAILED_ATTEMPTS”column，（in this case，the client 920 times）last check the client which Encryption mode used （caching_sha2_password/mysql_native_password or sha256），
The client's encryption method may be compatible with the mysql database


mysql> select * from information_schema.connection_control_failed_login_attempts;
+-----------------------------------------------+-----------------+
| USERHOST | FAILED_ATTEMPTS |
+-----------------------------------------------+-----------------+
| 'mysql_router5_da1ufs1lvt0b'@'192.168.200.153'| 26 |
| 'acolog'@'192.168.200.153' | 920 |
+-----------------------------------------------+-----------------+

3.stop the client connect or make sure the client use the right encryption method to connect mysql

goodluck!!!

by evils798