当TIDB作为mysql从库时如何配置为只读模式

  • After the read-only mode is enabled, all users (including the users with the SUPER privilege) cannot execute the SQL statements that might write data unless the user is explicitly granted the RESTRICTED_REPLICA_WRITER_ADMIN privilege.
    给root RESTRICTED_REPLICA_WRITER_ADMIN权限试试