Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Description
create user foo; |
create database db; |
create table db.t (a int); |
|
--connect (con1,localhost,foo,,)
|
grant all on db.t to foo; |
10.5 6cee9b195 |
MariaDB [test]> grant all on db.t to foo; |
ERROR 1142 (42000): SELECT, INSERT, UPDATE, DELETE, command denied to user 'foo'@'localhost' for table 't' |
Note that the list of privilege is truncated.
Reproducible on all of 5.5-10.5.
Fixed in MySQL 5.6+.
Patch: https://github.com/MariaDB/server/commit/8a58299028f4b90aa4c1abcd9feb1ecb689ea813