How to configure Mysql server as read-only

Sometimes we need to configure Mysql server as readonly. This is mainly required on setting replication servers.

In order to configure Mysql server as readonly, we need to add the following line in Mysql configuration file /etc/my.cnf.

read_only=1

Then restart Mysql service

#service mysqld restart

The Mysql server will be a read-only database server now.

Please note that the super user will still be able to modify the schema and also the replication will not be affected.