Spracherkennung für: .test vermutete Sprache: SQL {SQL[99] Lisp[72] Masm[72]} [Methode: maximale Elemente, drei Dimensionen]
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;
disconnect conn1;
drop user mysqltest;
drop table t1;
set @@global.query_cache_size=@save_query_cache_size;
set global query_cache_type=default;
[Dauer der Verarbeitung: 0.10 Sekunden, vorverarbeitet 2026-10-08]
