1#
2# Bug#58669: read_only not enforced on 5.5.x
3#
4CREATE USER user1@localhost;
5CREATE DATABASE db1;
6GRANT ALL PRIVILEGES ON db1.* TO user1@localhost;
7CREATE TABLE db1.t1(a INT);
8connect  con1,localhost,user1,,;
9connection con1;
10SELECT CURRENT_USER();
11CURRENT_USER()
12user1@localhost
13SHOW VARIABLES LIKE "read_only%";
14Variable_name	Value
15read_only	ON
16INSERT INTO db1.t1 VALUES (1);
17ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
18connection default;
19disconnect con1;
20DROP DATABASE db1;
21DROP USER user1@localhost;
22