1** Setup ** 2 3SET @default_read_only = @@global.read_only; 4SET @default_super_read_only = @@global.super_read_only; 5SET @@global.read_only = OFF; 6SET @@global.super_read_only = OFF; 7CREATE TABLE t1 8( 9id INT NOT NULL auto_increment, 10PRIMARY KEY (id), 11name BLOB 12); 13INSERT INTO t1 VALUES (1, 'good'); 14SET @@global.super_read_only = OFF; 15SET @@global.read_only = OFF; 16SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'FAIL', 'OK') AS ro; 17sro ro 18OK OK 19SET @@global.super_read_only = ON; 20SELECT IF(@@global.super_read_only, 'OK', 'FAIL') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro; 21sro ro 22OK OK 23SET @@global.super_read_only = OFF; 24SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro; 25sro ro 26OK OK 27SET @@global.super_read_only = ON; 28SELECT IF(@@global.super_read_only, 'OK', 'FAIL') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro; 29sro ro 30OK OK 31SET @@global.read_only = OFF; 32SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'FAIL', 'OK') AS ro; 33sro ro 34OK OK 35** Creating new user with explicit super privilege** 36CREATE user sameea; 37GRANT SUPER ON *.* TO sameea; 38SET @@global.super_read_only = ON; 39** Connecting connn using username 'sameea' ** 40CREATE TABLE t2 41( 42id INT NOT NULL auto_increment, 43PRIMARY KEY (id), 44name BLOB 45); 46ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement 47not updating values 48INSERT into t1(name) values("aaassssssssddddddddffffff"); 49Got one of the listed errors 50UPDATE t1 SET name="samia" where id=1; 51Got one of the listed errors 52SELECT * FROM t1; 53id name 541 good 55'#--------------------FN_DYNVARS_140_03-------------------------#' 56CREATE TEMPORARY TABLE t3(a int); 57'#--------------------FN_DYNVARS_140_04-------------------------#' 58** Connection default ** 59SET Global super_read_only=OFF; 60** Connection connn ** 61CREATE TABLE t2 62( 63id INT NOT NULL auto_increment, 64PRIMARY KEY (id), 65name BLOB 66); 67updating values 68INSERT into t2(name) values("aaassssssssdddddddd"); 69UPDATE t2 SET name="samia" where id=1; 70** Connection default ** 71** Disconnecting connn ** 72DROP USER sameea; 73DROP TABLE t1; 74DROP TABLE t2; 75SET global super_read_only = @default_super_read_only; 76SET global read_only = @default_read_only; 77