Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
If 10.5+ (i.e. a server with new privileges added in 10.5) is started on 10.3 or earlier datadir, and before mysql_upgrade is run, ACL statements are executed, then those which grant new privileges seemingly succeed but don't do anything. I suppose it has something to do with non-existing mysql.global_priv, and the old mysql.user not containing columns for the new privileges, but I would expect an error.
10.5 fb70bb44d0 |
MariaDB [test]> create user u; |
Query OK, 0 rows affected (0.001 sec) |
|
MariaDB [test]> grant read_only admin on *.* to u; |
Query OK, 0 rows affected (0.000 sec) |
|
MariaDB [test]> show grants for u; |
+-------------------------------+ |
| Grants for u@% | |
+-------------------------------+ |
| GRANT USAGE ON *.* TO `u`@`%` | |
+-------------------------------+ |
1 row in set (0.000 sec) |