1Warnings: 2Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. 3Warnings: 4Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. 5# Query rewrite plugin was installed. 6INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement ) 7VALUES ( 'SELECT "original"', 'SELECT "rewritten"' ); 8CALL query_rewrite.flush_rewrite_rules(); 9Warnings: 10Warning 1681 'RESET QUERY CACHE' is deprecated and will be removed in a future release. 11CREATE USER mysqluser1@localhost; 12INSERT INTO query_rewrite.rewrite_rules ( pattern ) VALUES ( '' ); 13ERROR 42000: INSERT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 14INSERT INTO query_rewrite.rewrite_rules ( replacement ) VALUES ( '' ); 15ERROR 42000: INSERT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 16INSERT INTO query_rewrite.rewrite_rules ( enabled ) VALUES ( '' ); 17ERROR 42000: INSERT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 18INSERT INTO query_rewrite.rewrite_rules ( message ) VALUES ( '' ); 19ERROR 42000: INSERT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 20SELECT pattern FROM query_rewrite.rewrite_rules; 21ERROR 42000: SELECT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 22SELECT replacement FROM query_rewrite.rewrite_rules; 23ERROR 42000: SELECT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 24SELECT enabled FROM query_rewrite.rewrite_rules; 25ERROR 42000: SELECT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 26SELECT message FROM query_rewrite.rewrite_rules; 27ERROR 42000: SELECT command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 28UPDATE query_rewrite.rewrite_rules SET pattern = ''; 29ERROR 42000: UPDATE command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 30UPDATE query_rewrite.rewrite_rules SET replacement = ''; 31ERROR 42000: UPDATE command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 32UPDATE query_rewrite.rewrite_rules SET enabled = ''; 33ERROR 42000: UPDATE command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 34UPDATE query_rewrite.rewrite_rules SET message = ''; 35ERROR 42000: UPDATE command denied to user 'mysqluser1'@'localhost' for table 'rewrite_rules' 36CALL query_rewrite.flush_rewrite_rules(); 37ERROR 42000: execute command denied to user 'mysqluser1'@'localhost' for routine 'query_rewrite.flush_rewrite_rules' 38SELECT 'original'; 39rewritten 40rewritten 41Warnings: 42Note 1105 Query 'SELECT 'original'' rewritten to 'SELECT "rewritten"' by a query rewrite plugin 43DROP USER mysqluser1@localhost; 44Warnings: 45Warning 1620 Plugin is busy and will be uninstalled on shutdown 46# Query rewrite plugin was queued for uninstalling. 47