I have a replicated slave with "read_only=1" set in my.cnf
I have a user set up as follows:
If I log in as 'slave_user', I can create a temporary table, write to it, and then drop it successfully:
However, if I have not created a temporary table, and I start with:
I get the error: ERROR 1290 (HY000): The MariaDB server is running with the --read-only option so it cannot execute this statement
I have countless lines of application code which always checks to make sure a temporary table is dropped before creating it to avoid an "already exists" error. Always worked on MySQL 5.6 and lower, on the exact same slave database with read_only. After upgrading to MariaDB 10.1, this problem emerged.