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.

GrantPermissionsSecurity

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

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 AdministrationGrantPrivileges

0 likes · 8 min read

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

ITPUB

Jan 29, 2022 · Databases

Master MySQL Permissions: Granting Access, Skip-Grant Tables, and Security Best Practices

This guide explains MySQL’s permission system, shows how to configure remote access for the root user by setting the host field to ‘%’, granting all privileges, flushing privileges, and clarifies the role of the skip‑grant‑tables option, while detailing the underlying tables and privilege levels.

Database AdministrationGrantPermissions

0 likes · 7 min read

Master MySQL Permissions: Granting Access, Skip-Grant Tables, and Security Best Practices

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.

Database AdministrationGTIDGrant

0 likes · 8 min read

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

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.

Database SecurityGrantPartial Revokes

0 likes · 5 min read

Using Partial Revokes in MySQL 8.0.16 to Revoke Granular Permissions

Practical DevOps Architecture

Jun 24, 2016 · Databases

Resolving MySQL Replication Issues: Enabling log‑slave‑updates and Granting Remote Access

This article explains how to fix a three‑node MySQL replication chain where the intermediate slave cannot log updates and the downstream slave cannot connect, by adding the log‑slave‑updates option and granting the appropriate remote privileges.

BackendGrantdatabases

0 likes · 4 min read

Resolving MySQL Replication Issues: Enabling log‑slave‑updates and Granting Remote Access