DROP SCHEMA IF EXISTS bug53833;
CREATE SCHEMA bug53833;

USE bug53833;
CREATE TABLE t(i integer, j integer);

INSERT INTO t VALUES(1,2);
INSERT INTO t SELECT i*2, j*2 FROM t;
INSERT INTO t SELECT i*3, j*3 FROM t;
INSERT INTO t SELECT i*4, j*4 FROM t;
INSERT INTO t SELECT i*5, j*5 FROM t;
INSERT INTO t SELECT i*6, j*6 FROM t;
INSERT INTO t SELECT i*7, j*7 FROM t;

CREATE USER bug53833@localhost IDENTIFIED BY 'secret';

GRANT SELECT ON bug53833.t TO bug53833@localhost;