[MDEV-22909] ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist inconsistency/regression (on optimized builds) Created: 2020-06-16 Updated: 2020-06-26 Resolved: 2020-06-24 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System |
| Affects Version/s: | 10.5.4, 10.4.14 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Blocker |
| Reporter: | Roel Van de Paar | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | not-10.1, not-10.2, not-10.3, regression, security | ||
| Description |
|
|
| Comments |
| Comment by Roel Van de Paar [ 2020-06-16 ] |
|
History/possibly related: |
| Comment by Sergei Golubchik [ 2020-06-24 ] |
|
mysql.user is a view, its definer is mariadb.sys@localhost user. You delete this user — the view becomes not accessible. This is expected. |
| Comment by Roel Van de Paar [ 2020-06-25 ] |
|
serg Understood. How about the differences between the versions? |
| Comment by Sergei Golubchik [ 2020-06-25 ] |
|
The difference is due to the fact that 10.4 uses mysql.global_priv and older versions use mysql.user to store user information |
| Comment by Roel Van de Paar [ 2020-06-26 ] |
|
Aha, understood. Thank you for the input. |