BestHub
Sign in
Tag

grant

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 23, 2024 · Databases

Misuse of Wildcards in MySQL GRANT Statements Leads to Permission Errors and How to Avoid Them

This article explains how using the '_' and '%' wildcards in MySQL GRANT statements can unintentionally broaden privileges, illustrates the security risks with concrete examples and version‑specific behavior, and provides practical guidance on escaping wildcards, auditing existing grants, and preventing privilege loss.

MySQLPermissionsdatabase
0 likes · 14 min read
Misuse of Wildcards in MySQL GRANT Statements Leads to Permission Errors and How to Avoid Them
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
Mar 18, 2021 · Databases

Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication

The article experimentally evaluates three ways of creating replication users—only on the master, separately on master and slave with CREATE statements, and separately with GRANT statements—to show how each method affects MySQL 5.7 master‑slave replication, error handling, and compatibility with GTID and MySQL 8.0.

CreateDatabase AdministrationGTID
0 likes · 8 min read
Impact of Different Replication User Creation Methods on MySQL Master‑Slave Replication
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2021 · Databases

Using Partial Revokes in MySQL 8.0.16 to Revoke Granular Permissions

This article explains MySQL's Partial Revokes feature introduced in version 8.0.16, showing how to enable the partial_revokes system variable, grant and selectively revoke SELECT privileges at both coarse and fine granularity, and verify the resulting restrictions using SHOW GRANTS and the mysql.user table.

MySQLPartial RevokesPermissions
0 likes · 5 min read
Using Partial Revokes in MySQL 8.0.16 to Revoke Granular Permissions