1
by brian
clean slate |
1 |
DROP TABLE IF EXISTS table_11733 ;
|
2 |
grant CREATE, SELECT, DROP on *.* to test@localhost;
|
|
3 |
set global read_only=0;
|
|
4 |
create table table_11733 (a int) engine=InnoDb;
|
|
5 |
BEGIN;
|
|
6 |
insert into table_11733 values(11733);
|
|
7 |
set global read_only=1;
|
|
8 |
select @@global.read_only;
|
|
9 |
@@global.read_only
|
|
10 |
1
|
|
11 |
select * from table_11733 ;
|
|
12 |
a
|
|
13 |
11733
|
|
14 |
COMMIT;
|
|
15 |
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
|
|
16 |
set global read_only=0;
|
|
17 |
drop table table_11733 ;
|
|
18 |
drop user test@localhost;
|