Re: Problem with caching_sha2_password and proxy/proxied user

[Silvio Schloeffel]

To make it clear:

- with test_user_6 and sha265:password:
mysql> SELECT USER(), CURRENT_USER();
+-------------------+-----------------------+
| USER() | CURRENT_USER() |
+-------------------+-----------------------+
| test_user_6@db-01 | bc_monitoring_proxy@% |
+-------------------+-----------------------+
1 row in set (0,00 sec)

mysql> select @@proxy_user;
+-------------------------------------------+
| @@proxy_user |
+-------------------------------------------+
| 'test_user_6'@'10.234.16.0/255.255.255.0' |
+-------------------------------------------+
1 row in set (0,00 sec)


- with test_user_7 and caching _sha2_password:
mysql> SELECT USER(), CURRENT_USER();
+-------------------+---------------------------------------+
| USER() | CURRENT_USER() |
+-------------------+---------------------------------------+
| test_user_7@db-01 | test_user_7@10.234.16.0/255.255.255.0 |
+-------------------+---------------------------------------+
1 row in set (0,01 sec)

mysql> select @@proxy_user;
+--------------+
| @@proxy_user |
+--------------+
| NULL |
+--------------+
1 row in set (0,00 sec)


I mean, if caching_sha2 is the replacement for sha256 (marked as deprecated) and also if this is declared as the new standard this should work.

Best

Silvio