mysql 锁只读_mysql 从设置只读

read-only

该选项限制普通用户只有select权限

--read_only Make all non-temporary tables read-only, with the

exception for replication (slave) threads and users with

the SUPER privileg

使所有的非temporary表为只读,除了复制的threads和超级用户

超级用户:

SUPER privilege :

The SUPER privilege enables an account to use CHANGE MASTER TO , KILL or mysqladmin kill to kill threads belonging to other accounts (you can always kill your own threads), PURGE BINARY LOGS ,

configuration changes using SET GLOBAL to modify global system variables, the mysqladmin debug command, enabling or disabling logging, performing updates even if the read_only system variable is

enabled, starting and stopping replication on slave servers, specification of any account in the DEFINER attribute of stored programs and views, and enables you to connect (once) even if the

connection limit controlled by the max_connections system