Automating Threat Intelligence series
May 04, 2025
MySQL/MariaDB User Management
I’m now a DB admin and I always forget how to manage MySQL/MariaDB users. Here are some self-notes to not search over and over the same topic on Google.
Delete user:
DROP USER IF EXISTS user;
Create user:
CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass';
Grant privileges:
GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'localhost';
or
GRANT ALL PRIVILEGES ON database_name.* TO 'user'@'%';
Show User-Specific Grants:
SELECT Host,User from mysql.user;
Show Database-Specific Grants:
SELECT * FROM mysql.db;
Show Table-Specific Grants:
SELECT * FROM mysql.tables_priv;
Show Column-Specific Grants:
SELECT * FROM mysql.columns_priv;