blob: f5052702768d91a14680d6e3c7d0fd3a4cb29fec (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
set @save_query_cache_size=@@global.query_cache_size;
--source include/not_embedded.inc
--source qc_info_init.inc
# try an unprivileged user
create user mysqltest;
grant select on test.* to mysqltest;
connect (conn1,localhost,mysqltest,,);
connection conn1;
select a from t1;
select count(*) from information_schema.query_cache_info;
connection default;
drop user mysqltest;
drop table t1;
set @@global.query_cache_size=@save_query_cache_size;
set global query_cache_type=default;
|
