BestHub
Sign in
Tag

Privileges

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 15, 2024 · Databases

Analysis of MySQL GRANT Failure in Replication and Its Non‑Atomic Behavior

This article investigates why a MySQL replication slave stops when a GRANT statement fails after directly updating the mysql.user table, explains the implicit privilege reload mechanism, demonstrates the issue with a reproducible test, and concludes that GRANT is not an atomic operation.

Database AdministrationMySQLPrivileges
0 likes · 8 min read
Analysis of MySQL GRANT Failure in Replication and Its Non‑Atomic Behavior
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 27, 2023 · Information Security

Comparison of User Management and Access Control between OceanBase (MySQL Mode) and MySQL

This article compares OceanBase (MySQL mode) and MySQL in terms of user management, password syntax, user locking, permission levels, grant statements, grant tables, network white‑list access control, row‑level security, and role management, highlighting similarities, differences, and migration considerations.

Access ControlMySQLOceanBase
0 likes · 18 min read
Comparison of User Management and Access Control between OceanBase (MySQL Mode) and MySQL