MySQL Read Only

Here’s how to make a MySQL database read only.

<pre lang="bash">
mysql> FLUSH TABLES WITH READ LOCK;
mysql> SET GLOBAL read_only = ON;

It’s very useful if creating a replica database.