How to Check if MySQL Instance is read only

In order to find out if your DB server in read mode or read/write mode.

Follow the below Steps:

• Login into your DB Server using MySQL Tools,Mysqlem etc.
• Run below queries:
• SELECT @@global.read_only;
• If the Output is 1, it means DB server is read only.
• else if Output is 0, it means DB server is both read/write.

Enjoy Reading.