Bug #107233 | update mysql.user to modify user password no effect | ||
---|---|---|---|
Submitted: | 7 May 2022 1:10 | Modified: | 7 May 2022 20:47 |
Reporter: | link link | Email Updates: | |
Status: | Unsupported | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.6.25 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[7 May 2022 1:10]
link link
[7 May 2022 20:47]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat behavior of quite older version 5.6.25 and EOL version too: mysql> update mysql.user set authentication_string=password("Cr66@") where User="archery" and Host="%"; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> sELECT user, host,authentication_string from mysql.user; +---------+-----------+-------------------------------------------+ | user | host | authentication_string | +---------+-----------+-------------------------------------------+ | root | localhost | | | root | 127.0.0.1 | | | root | ::1 | | | | localhost | NULL | | archery | % | *E350AA6BE5E92584862793A4EA316802CF1C7FD8 | +---------+-----------+-------------------------------------------+ 5 rows in set (0.00 sec) mysql> show variables like "%version"; +------------------+------------+ | Variable_name | Value | +------------------+------------+ | innodb_version | 5.6.51 | | protocol_version | 10 | | version | 5.6.51-log | +------------------+------------+ 3 rows in set (0.00 sec) https://www.mysql.com/support/eol-notice.html "MySQL 5.6 is covered under Oracle Lifetime Sustaining Support Per Oracle's Lifetime Support policy, as of February 1, 2021, MySQL 5.6 is covered under Oracle Sustaining Support. Users are encouraged to upgrade to MySQL 8.0."